Fixed X-Axis (-100 to + 100) in chart

Hi,
I have a problem to get a fixed X-Axis in my chart.
I need a scale from -100 to +100 which does not depend on the values that come from my database. At this moment The scale increases or decreases when I for example only have values between 20 and 30. This is not useful for comparing different charts.
I tried different settings for the chart (setting maximum to 100 and minimum to -100 and Cross at 0) without effect.
Anyone got a suggestion? Thanks!Pull up chart properties dialog, go to X Axis tab, and check the "Numeric or
timescale values" checkbox.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jan" <Jan@.discussions.microsoft.com> wrote in message
news:9B4FCC9E-9CCD-44C9-A198-CF268D3A5053@.microsoft.com...
> Hi,
> I have a problem to get a fixed X-Axis in my chart.
> I need a scale from -100 to +100 which does not depend on the values that
come from my database. At this moment The scale increases or decreases when
I for example only have values between 20 and 30. This is not useful for
comparing different charts.
> I tried different settings for the chart (setting maximum to 100 and
minimum to -100 and Cross at 0) without effect.
> Anyone got a suggestion? Thanks!|||You will also need to set the Scale Minimum and Maximum on the X Axis tab
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
news:%239fYJXnaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> Pull up chart properties dialog, go to X Axis tab, and check the "Numeric
or
> timescale values" checkbox.
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Jan" <Jan@.discussions.microsoft.com> wrote in message
> news:9B4FCC9E-9CCD-44C9-A198-CF268D3A5053@.microsoft.com...
> > Hi,
> >
> > I have a problem to get a fixed X-Axis in my chart.
> >
> > I need a scale from -100 to +100 which does not depend on the values
that
> come from my database. At this moment The scale increases or decreases
when
> I for example only have values between 20 and 30. This is not useful for
> comparing different charts.
> >
> > I tried different settings for the chart (setting maximum to 100 and
> minimum to -100 and Cross at 0) without effect.
> >
> > Anyone got a suggestion? Thanks!
>|||Thanks for both tips. Fixed my problems (and axis...).
"Bruce Johnson [MSFT]" wrote:
> You will also need to set the Scale Minimum and Maximum on the X Axis tab
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ravi Mumulla (Microsoft)" <ravimu@.online.microsoft.com> wrote in message
> news:%239fYJXnaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> > Pull up chart properties dialog, go to X Axis tab, and check the "Numeric
> or
> > timescale values" checkbox.
> >
> > --
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > "Jan" <Jan@.discussions.microsoft.com> wrote in message
> > news:9B4FCC9E-9CCD-44C9-A198-CF268D3A5053@.microsoft.com...
> > > Hi,
> > >
> > > I have a problem to get a fixed X-Axis in my chart.
> > >
> > > I need a scale from -100 to +100 which does not depend on the values
> that
> > come from my database. At this moment The scale increases or decreases
> when
> > I for example only have values between 20 and 30. This is not useful for
> > comparing different charts.
> > >
> > > I tried different settings for the chart (setting maximum to 100 and
> > minimum to -100 and Cross at 0) without effect.
> > >
> > > Anyone got a suggestion? Thanks!
> >
> >
>
>