ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2 Charts on 1 Graph: 2 Y-axis? (https://www.excelbanter.com/excel-programming/324754-2-charts-1-graph-2-y-axis.html)

Mike

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


Gary Brown[_5_]

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



crossingmind

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.


Mike

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