Apr 16 2023 11:50 PM
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 feels a lot different and not nearly as "intuitive" as I remember.
The issue I am having has to do with the Vertical and Horizontal axis formatting. I seem to recall the entries/values defaulted to the contents of the referenced cells. In this newer version, the default seems to default with Percentages 0% to 100% which I assume is based on the cell contents. I cannot see where to change that to relate to the values in the referenced cells. I am plotting a list of numbers against a year's value 2010 - 2020 for example. That might be the horizontal values while the vertical could be adjusted to 1000 to 3000 for example with graph data containing random values which might be 1500 through 2500. This used to be "automatic" in older 'legacy' versions of EXCEL where you would select your data and insert the graph which would start as what you were looking for. Then you could mess around with the Axis formats to stretch or compress the data range to suit your presentation needs. A normally very basic and super easy process. Now, I am stuck with 0% - 100% based on the contents of the cells. In the above example where data was random between 1500 and 2500, the 100% might relate to 2500 or maybe slightly higher. I am getting pretty old for this (!) and embarrassed to have to ask.
DaveR KB7GP
Apr 17 2023 02:45 AM
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:
Apr 17 2023 02:11 PM
Apr 17 2023 02:30 PM
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:
Apr 17 2023 03:56 PM
Apr 18 2023 03:46 AM
No, a chart can only have one primary value axis and one secondary value axis. That's it.
Apr 18 2023 02:59 PM