Pivot Chart Value Axis Scaling Question

[farrell77]

I have a pivot chart that displays 3 data series.

Series 1 values range from 17 to 106.
Series 2 values range from 1 to 18.
Series 3 values range from 0 to 1.

When I display all three series on the chart, the value axis labels run from
1 to 120 with major unit lines at intervals of 20.

When I remove Series 1, the chart automatically adjusts itself and the
value axis labels run from 1 to 20 with lines at intervals of 2, thus
nicely accommodating the value ranges of Series 1 and Series 2.

All this is fine. But when I remove Series 2, leaving only Series 3,
the labels run from 1 to 1.2 with interval spacing of .2. Since these
values are counts, it makes little sense to show decimal values.

Can anyone provide advice on how to keep these axis labels from
showing decimal values, if a user removes Series 1 and Series 2?

Thanks.

- Bob

[Erland Sommarskog]

Re: Pivot Chart Value Axis Scaling Question

farrell77 (farrell77@spam free.yahoo.com) writes:[color=blue]
> I have a pivot chart that displays 3 data series.
>
> Series 1 values range from 17 to 106.
> Series 2 values range from 1 to 18.
> Series 3 values range from 0 to 1.
>
> When I display all three series on the chart, the value axis labels run[/color]
from[color=blue]
> 1 to 120 with major unit lines at intervals of 20.
>
> When I remove Series 1, the chart automatically adjusts itself and the
> value axis labels run from 1 to 20 with lines at intervals of 2, thus
> nicely accommodating the value ranges of Series 1 and Series 2.
>
> All this is fine. But when I remove Series 2, leaving only Series 3,
> the labels run from 1 to 1.2 with interval spacing of .2. Since these
> values are counts, it makes little sense to show decimal values.
>
> Can anyone provide advice on how to keep these axis labels from
> showing decimal values, if a user removes Series 1 and Series 2?[/color]

All I can make out of this, is that the question has nothing to do
with SQL Server. You should find a newsgroup for the tool you are using.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[farrell77]

Re: Pivot Chart Value Axis Scaling Question

Yes, wrong newsgroup, sorry. My mistake

"Erland Sommarskog" <esquel@sommars kog.se> wrote in message
news:Xns9616F2D 01A4E0Yazorman@ 127.0.0.1...[color=blue]
> farrell77 (farrell77@spam free.yahoo.com) writes:[color=green]
> > I have a pivot chart that displays 3 data series.
> >
> > Series 1 values range from 17 to 106.
> > Series 2 values range from 1 to 18.
> > Series 3 values range from 0 to 1.
> >
> > When I display all three series on the chart, the value axis labels run[/color]
> from[color=green]
> > 1 to 120 with major unit lines at intervals of 20.
> >
> > When I remove Series 1, the chart automatically adjusts itself and the
> > value axis labels run from 1 to 20 with lines at intervals of 2, thus
> > nicely accommodating the value ranges of Series 1 and Series 2.
> >
> > All this is fine. But when I remove Series 2, leaving only Series 3,
> > the labels run from 1 to 1.2 with interval spacing of .2. Since these
> > values are counts, it makes little sense to show decimal values.
> >
> > Can anyone provide advice on how to keep these axis labels from
> > showing decimal values, if a user removes Series 1 and Series 2?[/color]
>
> All I can make out of this, is that the question has nothing to do
> with SQL Server. You should find a newsgroup for the tool you are using.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp[/color]