| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
could I have dual scales on the same axis
All:
I's trying to three lines on the same axis. However one of the lines has enormous values while the others are relatively small. Is there anyway to have dual scales on the same axis? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
could I have dual scales on the same axis
It's not too hard if you don't mind faking it:
One way: http://peltiertech.com/Excel/Charts/BrokenYAxis.html Another way, put the scales in different layers and leave out the separating lines: http://peltiertech.com/Excel/Charts/StackedLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Steve" wrote in message ... All: I's trying to three lines on the same axis. However one of the lines has enormous values while the others are relatively small. Is there anyway to have dual scales on the same axis? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dual Y Axis in Line Plots | Excel Discussion (Misc queries) | |||
| broken scales for X axis | Charts and Charting in Excel | |||
| Chart with dual Y axis data | Excel Worksheet Functions | |||
| Stacked AND Clustered AND Different axis scales | Charts and Charting in Excel | |||
| "Broken" chart axis for data of different scales | Charts and Charting in Excel | |||
Linear Mode
