February 16, 2011 at 12:35 pm
Hello:
I have a bar chart whose vertical axis displays revenue dollars. I have custom min and max values for the axis's range. When the chart displays, it shows labels by the tick marks on the vertical axis with numbers like this:
$119,114,271
$95,223,898
$71,333,525
etc.
How can I get the labels to round up to the nearest million? So it would display like this:
$120,000,000
$96,000,000
$72,000,000
etc.
Thanks!
February 17, 2011 at 1:21 am
does setting the interval to 1000000 work?
February 17, 2011 at 7:48 am
Hi, Bulbanos:
Thanks for the reply! Unfortunately, I tried setting the interval to 10 million (setting it to 1 million results in too many tick marks since the total is so large), but that just gives me the non-rounded numbers in increments of 10 million, e.g.,
$109,662,405
$99,662,405
$89,662,405
etc.
Any other ideas?
February 17, 2011 at 8:03 am
I'm not a 100% sure but I think the LabelIntervalOffset property on the y-axis is what you're looking for.
It seems like for some reason you have 662,405 as starting point? Add -662,405 as value to LabelIntervalOffset and tell me how it looks like.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply