Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel graphics | New Users to Excel | |||
Excel Graphics | Charts and Charting in Excel | |||
True 3D graphics in Excel | Charts and Charting in Excel | |||
Excel Add-in for better graphics | Excel Programming | |||
Excel VBA - Graphics | Excel Programming |