Formidable Info About Is It Possible To Have Two Y Axis In Excel When Use A Line Chart
Displaying multiple series in one excel chart.
Is it possible to have two y axis in excel. This is a trivial case, and probably not what. You can either add the secondary axes after creating a. It appears a secondary y axis.
You can make your xy chart with both dataset. I’ll show all the steps necessary to. Other way would be to chart the 3rd one separately, and overlay.
It allows for simultaneous comparison of different data series. Displaying multiple series in an xy scatter chart. There is a way of displaying 3 y axis see here.
Then double click on one series, and on the axis tab, select secondary. Excel supports secondary axis, i.e. It can mislead a viewer into making correlations between data that are not accurate, since the two y axis hold no reasonable relationship.