Hello friends,
I am trying to increase the space (pitch) between the maximum and minimum values, which is indicated by red colour in the following graph. Although the difference between both values are quite closer to each other.
Waiting for your earliest answer
Perhaps this source can help you:
https://support.microsoft.com/en-us/office/change-the-scale-of-the-vertical-value-axis-in-a-chart-05973661-e56a-4486-a9f3-f9ce41df0021
Hello Anton , as I went to this link, but I couldn't find the answer to my question.
Hello Nelaturi,
I do not understand what is mean by " three decimal class range".
could you please share some link or elaborate a bit?
Pankaj, in Excel it is very easy. Select the y axis, right click and from the menu select Format axis. There you can change the min and max values.
Hello Mihail, Yes you are true, but I am looking to increase the space between maximum and minimum values in the red marker on the graph(see the attached graph) So just changing the value of ticks will increase the space between ticks on y-axis and not on the actual value, which is indicated in red colour on the graph.
Well, then you just change the scale (let say multiply all values by 100). See the chart attached - same data before and after scaling...
Thanks for an answer but the change the values on y-axis will affect the units. I am looking for a solution with original values.
Hello all thanks for your answer, however you can see the final answer to my question
This is exactly what I told you - to change the original values (multiply by 100 for example) not the axis! Check my answer again! Then only this part of the global chart will change and you don't need to mix charts.
- Badges
- Science topic