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]

farrell77 (fa*******@spamfree.yahoo.com) writes:

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?

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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[farrell77]

Yes, wrong newsgroup, sorry. My mistake

"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...

farrell77 (fa*******@spamfree.yahoo.com) writes:

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?

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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp