Ask Your Question

How to make different net charts with same 0-100 range, when data is so different?

asked 2018-05-15 15:53:18 +0100

Qasherto gravatar image

updated 2018-05-15 15:54:22 +0100


Apologizes if I'm not good with explaining it in title. I'll try to use examples for this.

I need to make net charts and show them in comparison with one another, range being 0 - 100. But no matter what I do, I can not get chart to retain 0-100 range when highest data in specific chart is only 50.

For example, when highest data is 51, ranges are from 0 - 100 as needed:

image description

But when highest data is 50, ranges drop to 0-50.

image description

I need to have several of them next to one another for specific presentation, all with ranges 0-100 to show visual differences and it fails if one chart has range 0-100 and other 0-50.

Is there a way to make chart stay 0-100 even when highest data in it is below 50?

edit retag flag offensive close merge delete


See answer below.

ve3oat gravatar imageve3oat ( 2018-05-16 04:04:28 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-05-16 04:07:47 +0100

ve3oat gravatar image

updated 2018-05-16 19:03:56 +0100

Double click on the offending chart. Let the cursor hover over a radial line on the chart. A pop-up will say "Y axis". Right-click at that point. A dialog box will appear. Choose Format Axis. Another dialog box will appear. Choose the "Scale" tab which will give you options to change and edit the scale of the y-axis. Be sure to uncheck "Automatic" and enter the values that you want (maximum = 100).

When you are done, click OK. Then click on an empty cell away from the chart to take it out of edit-mode. Be aware that some (many?) changes will not actually be displayed until you take the chart out of edit-mode.
As far as I know, most or all charts can be edited in this way. Being able to format the axes is a very valuable tool, and I use it often myself. Similarly you can also edit the axis labels, titles, data point symbols, etc. Right-click on an object and choose your weapon, as they say.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more


Perfect and extremely helpful answer! THANK YOU!

Qasherto gravatar imageQasherto ( 2018-05-18 16:43:29 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-15 15:53:18 +0100

Seen: 38 times

Last updated: May 16 '18