Sunday, February 19, 2012

Chart Axis

I have created a bar chart with percentages as the variables. The numbers on
the chart are correct, but the scale is incorrect. The scale adjusts to 100%
for all fields.
Anyone else encountered this problem?
--
TDWhen using percentages (e.g. format code P on the Y-axis), you can either
auto-scale the axis or you can specify an explicit min/max value. If you
specify an explicit max value (e.g. 120%), you have to specify it as 1.2
rather than 120
For percentages, 1 means 100%.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"TDahlin" <TDahlin@.discussions.microsoft.com> wrote in message
news:D87A2D0A-D607-4483-A3B4-484A07B2C5AC@.microsoft.com...
>I have created a bar chart with percentages as the variables. The numbers
>on
> the chart are correct, but the scale is incorrect. The scale adjusts to
> 100%
> for all fields.
> Anyone else encountered this problem?
> --
> TD

No comments:

Post a Comment