ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel graphics (https://www.excelbanter.com/excel-programming/394079-excel-graphics.html)

albatros[_2_]

excel graphics
 
hi,
I try to find a graphic with two y axis, one is left ant the other one is
right...is it possible at excel ??? or any alternative way ?

thank you
sincerely...

Peter T

excel graphics
 
Are you talking about a Chart with two Y axes, if so -

Create a chart with at least two series

Right click the chart area
Chart type....
Custom types
(ensure the 'Built in' option is selected)
Line - column on 2 axes [or] Lines on 2 axes

Alternatively,
Select a series you want displayed on the 2nd axis
Right-click Selected object
Axis
select the secondary axis option

Perhaps before applying the axis, change the Chart type of each series you
want displayed on the 2nd axis to a Line type. (If you want all 'fill' type
series you will need to include additional dummy series to be displayed on
the 1st axis which will be hidden by those on the 2nd axis)

Regards,
Peter T

"albatros" wrote in message
...
hi,
I try to find a graphic with two y axis, one is left ant the other one is
right...is it possible at excel ??? or any alternative way ?

thank you
sincerely...





All times are GMT +1. The time now is 03:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com