excel graphics

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best method / software for graphical output from dynamic excel data 0
Chart Question 1
Dell Optiplex graphics driver failure 2
Exel - add vertical line to two axis graph 0
create chart with column axis 10
VBA set thick borders around non empty cells in range 0
All possible combinations of data inputted under three headings 1
Graphic but referencing the values range for Y axis in an externalcell (indirect reference) 1

Back
Top