Whole values on bar chart axis

[bwysocki]

Another CR7 bar chart question for you all. I have an auto ranging Y-axis on my bar chart. The numbers have been formatted to display zero decimal places. The only numbers that will get displayed on the chart are whole numbers. Yet given the right data I sometimes get a chart that has axis values that are 1, 1, 2, 2, 3, 3 etc..

Is there any way to force a chart to only display axis values as whole numbers?

One other tidbit of info, I never know the maximum value of the numbers displayed in my chart, so displaying axis values within a specific range would be difficult.

Bob

 

[gonetkeygo]

just wondering if you found the answer to this problem. i have the same issue and can't figure it out.

thanks,

joe

 

[bwysocki]

If I remember correctly what we ended up with was a kludge at best.

We ended up creating multiple charts with different fixed ranges. Depending on the values, one chart was displayed and the others hid.

 

[gonetkeygo]

thanks. i might end up doing the same thing.