Forum Discussion
Excel chart Axis
I want my graph to automatically scale itself relevant to the data. The axis default is always Min 0.0 and Max 1.0 which is not suitable for my data range.
I have the option to reset and when I select this my scale automatically changes to a correct one, however once I save the excel sheet the graph scales return to Min 0.0 and max 1.0
How can I prevent it from doing this?
1 Reply
- Hello,
Clicking on Reset gets you back in Automatic scale, which means the min or max depends on the actual data. To set a specific scale, just enter your own min or max in the corresponding edit box. And do not click on Reset after !
