Forum Discussion
how to remove unwished ranges or how to shrink the displayed part of a Graph/Chart
Dear all I have a defined Chart and I would 'restrict' the area of the x-axis that is shown w/o creating a different chart. I know how to restrict the values on the y-axis. Is there a similar ...
I will try this on another case.
It does not really solve the generic issue.
BTW why Date should be the only case where this option is possible.
I really cannot understand.
It does not really solve the generic issue.
BTW why Date should be the only case where this option is possible.
I really cannot understand.
For most chart types, Excel treats the x-axis as text unless it is a date axis. Setting a minimum and maximum of text values makes no sense.
If you change the chart type to XY Scatter, you can specify the minimum and maximum values for the x-axis: