User Profile
ScubaSam
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Cannot Adjust X-Axis Range
I have been having this issue since I started making plots in excel. When using any plot other than a scatter plot, I cannot adjust the X-axis range. I've searched the web for a solution countless times, and all that I have learned is that people have been having this problem since before 2016. I'm hoping I can at least figure out what is happening behind the scenes, because I cannot imagine why anyone would design a plotting tool without the ability to manually adjust the range of plots. It must bepossible... Here, I am using a combo plot. The blue area-chart is used to show a number of frequency bands. This is just a visual guide so that a viewer knows which parts of the line-chart contain interesting data. What I want to do is adjust the X-axis range to eliminate the white space to the left of the data. When I use the "axis options" tab to try to format the X-Axis, there is no option to adjust the range. All it says is that excel has already made all of these decisions for me. All of the data is numerical. All of the cells are formatted as numbers. So why can't I change the x-axis range of this plot? In this same plot, I can adjust the y-axis range just fine. Here is what that looks like.
