ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can I have two sets of scales on one axis? (https://www.excelbanter.com/charts-charting-excel/132101-can-i-have-two-sets-scales-one-axis.html)

Steven

Can I have two sets of scales on one axis?
 
Hi,

I'm trying to have three sets of scales on one graph, 1 on the left
axis and 2 on the right. Is this doable?

Thanks,
Steven


Jon Peltier

Can I have two sets of scales on one axis?
 
This isn't native to Excel, but you can fake it.

The fake is a modification of the Tertiary Axis example on my web site, but
you put the fake axis on the right, and adjust where the axis decorations
appear. It might be easier to put two fake axes on the right than try to
make a fake one and real one coexist. This allows you to plot all data on
the primary axis, but you'll need to transform your secondary and tertiary
data so it matches the scales you want to show.

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

Related Examples:
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
http://peltiertech.com/Excel/Charts/StackedCharts.html
http://peltiertech.com/Excel/ChartsH...nelChart1.html

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


"Steven" wrote in message
ps.com...
Hi,

I'm trying to have three sets of scales on one graph, 1 on the left
axis and 2 on the right. Is this doable?

Thanks,
Steven




Steven

Can I have two sets of scales on one axis?
 
Thank you!



All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com