Charts

T

tec

i want to be able to create a double y axis graph to plot 4 elements - 1 element using one y axis and 3 elements using the second y axis. is this possible?
 
T

Tushar Mehta

Yes, assuming that 'elements' refers to what XL/Graph call series.
Plot all four series. For each series you want to move to the
secondary y axis, double-click the series, and in the resulting dialog
box, in the Axis tab, select 'Secondary'.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
E

Echo S

tec said:
i want to be able to create a double y axis graph to plot 4 elements - 1
element using one y axis and 3 elements using the second y axis. is this
possible?

Yes, it's possible.
 

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

Top