Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can I have two sets of scales on one axis?
Thank you!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two series, two scales on single axis ? | Charts and Charting in Excel | |||
could I have dual scales on the same axis | Charts and Charting in Excel | |||
broken scales for X axis | Charts and Charting in Excel | |||
having problems with X-axis scales | Excel Discussion (Misc queries) | |||
Two different y-axis scales? | Charts and Charting in Excel |