Forum Discussion
KB7GP
Apr 17, 2023Copper Contributor
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...
KB7GP
Apr 17, 2023Copper Contributor
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
HansVogelaar
Apr 17, 2023MVP
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:
- KB7GPApr 17, 2023Copper ContributorI 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.
- HansVogelaarApr 18, 2023MVP
No, a chart can only have one primary value axis and one secondary value axis. That's it.
- KB7GPApr 18, 2023Copper Contributor