Forum Discussion
SIMPLE LINE CHART/GRAPH DEFINING AXIS VALUES
I am not a 'Pro' user of EXCEL but I have had a lot of experience with it (legacy-wise that is)... Working with charts and graphs used to be easy for me. With the latest Office 365 subscription, it f...
Your description makes me think that you have selected one of the "100% Stacked" chart types, such as "100% Stacked Column", "100% Stacked Bar" or "100% Stacked Line":
Such charts always have a y-axis that goes from 0% to 100%.
Try changing the chart type to one of the Clustered types:
Thank you! That seems to do it. I guess it pays to actually 'read' the graph description and not just select the icon.
I have seen graphs that have two scales on the Left in the primary as well as a secondary on the Right side. Is this possible with EXCEL?
DaveR
I have seen graphs that have two scales on the Left in the primary as well as a secondary on the Right side. Is this possible with EXCEL?
DaveR
If your chart has multiple series, you can specify that one or more of them will be displayed on a secondary axis.
To do so: double-click a series on the chart. This will activate the Format Data Series task pane:
- I know that one and today I discovered that I could move that axis all the way to the left so that it joins the primary axis. This leaves no labeling on the right side of the chard. So, I guess my question might be to ask if there is a possibility of a third or more axis labels.
No, a chart can only have one primary value axis and one secondary value axis. That's it.