Control data association in double-y chart

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

Guest

I'm trying to make a double y-axis chart where three data sets appear on (are associated with) one axis and the fourth data set is associated with the other. By every method of data import that I've tried, the data sets are split two and two for each of the y-axes. Can anyone help me

I'm using the Lines on 2 Axes Chart Type from the Built In Custom Type list. If I could do a double-y chart using a x-y scatter chart, it would be even better.

Thanks for any help
--Mike
 
Mike -

Who needs the built-in custom types? Make your XY Scatter chart with all
the data, then double click the oddball series, and on the Axis tab of
the Format Series dialog, select Secondary.

- Jon
 
Jon
I've seen that Secondary Axis show up but grayed out.
Now I know how to get at it
Thanks
Mike
 
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

how to switch the primary and secondary Y axis to opposite chart s 2
Switch x and y axes 3
three y axes 2
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Line chart - time series - category axis date format (2007 VBA) 1
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Combined line-scatter graph with 2 Y-axis messed up 2

Back
Top