Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 Charts on 1 Graph: 2 Y-axis?
Hi everyone,
Say you have two charts that you want to put on Y-axis: I mean the left Y-axis for one, and the right Y-axis for the other. How can you do that? Thanks, Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 Charts on 1 Graph: 2 Y-axis?
Right click the series that you want to change to the secondary axis. A menu
will appear. Select 'Format Data Series'. Select 'Axis' tab. Select 'Secondary'. HTH, Gary Brown "Mike" wrote: Hi everyone, Say you have two charts that you want to put on Y-axis: I mean the left Y-axis for one, and the right Y-axis for the other. How can you do that? Thanks, Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 Charts on 1 Graph: 2 Y-axis?
I think the easiest way is:
1. highlight your data array 2. click the graph icon, select the tab "custom types" 3. select Line/column on two axes type of graphs. Select the type you want (line-line, or column-line). 4. Then you'll get the two y axis chart. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 Charts on 1 Graph: 2 Y-axis?
Big THANK YOU all...........
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want graph with 2 axis, but bars overlap when second axis added | Charts and Charting in Excel | |||
how can i plot two different y-axis graph with same x-axis | Excel Discussion (Misc queries) | |||
y-axis versus x-axis charts | Charts and Charting in Excel | |||
can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |