![]() |
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 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 |
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. |
2 Charts on 1 Graph: 2 Y-axis?
Big THANK YOU all...........
|
All times are GMT +1. The time now is 04:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com