How do I either hide a bar on a chart or fix the vertical axis? I have any month
ID: 3563122 • Letter: H
Question
How do I either hide a bar on a chart or fix the vertical axis?
I have any monthly charts showing values. but when the values are too low for a month, the system generates a different vertical scale.
Therefore, I placed a fake value as the first bar for the graph. This makes all charts scale to 3000.
Can I now hide that first fake value?
or
Can I instead fix the scale for all values even if they are low and drop the fake value.
Also, when I choose another range, the settings for the horizontal axis get dumped.
How do I prevent this or do I have to re-enter them every time?
Thanks,!
Explanation / Answer
Right-click one of the labels along the vertical axis.
Select Format Axis from the context menu.
Click Axis Options.
Click Fixed next to Maximum, then enter the maximum value that you want to set.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.