Hey,
So I have a chart that shows millions on the vertical axis. When I right click on the axis and click format axis, I go to scale and change the number of display units to millions. This works fine as for example it changes the number on the vertical axis from 1,000,000 to 1M.
However, the labels on the bar charts change from 1,234,567 for example to 1 but I don't want the label format to change I want it to stay the same. I'm not sure why the remainder of the number is getting cut off. Please advise how to fix this.
Bookmarks