Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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.

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote