Forum Discussion
Cannot Adjust X-Axis Range
Riny_van_Eekelen Thank you. That works, and answers the question - how to change the range. What of the other parameters that I have no control over in this case? Major and minor gridlines(units) for example?
I often make adjustments to plots mid-presentation; changing scales and data ranges to get a closer look at different ranges data. For example, if I copy-paste the same exact data into a scatter plot, then I have full control over the range/units of both the X and Y axes by simply using the "format axis" window. Using this other method, all data above or below a certain range is completely excluded from the plot, and I would need to make many copies of the same plot to accomplish this.
There must be a work-around for this automatic range "feature".
So I ran into this issue when I did "change chart type" trying to add a secondary axis under the "combo" chart type. When you select or change the chart type, you'll see it do something with the x axis, simply I just selected a chart type where it it let me use normal number ranges.