ExcelBanter - 3 of 4 Y axes

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - 3 of 4 Y axes (https://www.excelbanter.com/charts-charting-excel/40378-3-4-y-axes.html)

I have a chart that has a Y axis on the left and on the right side of the
chart. Is there any way to have 2 Y axes on the left and 2 on the right? I
would like to be able to compare 4 sets of data at the same time and the
range of values might be much different.
Thanks in advance,
Kelly

Kelly -

You can extend this technique to a quaternary axis:

http://peltiertech.com/Excel/Charts/TertiaryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Kelly McFaul wrote:

I have a chart that has a Y axis on the left and on the right side of the
chart. Is there any way to have 2 Y axes on the left and 2 on the right? I
would like to be able to compare 4 sets of data at the same time and the
range of values might be much different.
Thanks in advance,
Kelly