Combination Chart Creation

[Queenlinker]

I am trying to creat a chart with 2 lines both on the y-axis but add a column on the x-axis however I already have the axis with the months of the year.
Data:
Jan 02 - Dec 02
Y-axis "Yields" ranging frrom $185.00 to $220.00 (line)
Secondary Y-axis "Commission's Paid" ranging from $6.00 to $14.00 (line)
I want to add "Membership" for each month on the X-axis as a column - How do I do this? The values range from 20000 to 30000

 

[Mark W.]

You can only have a primary and a secondary Y-axis. Which on these 3 series to you intend to have on each Y-axes?

 

[Queenlinker]

Is there anyway to chart 3 data series on the same chart?

 

[Mark W.]

Yes, but you must decide which y-axis (primary or secondary) you intend to use for each. In your description above you have assigned dollar values to both axes. Where are you going to plot memberships?
This message was edited by Mark W. on 2002-10-28 12:39

 

[Queenlinker]

I want to use both dollar values as my y-axis's and use the membership on the x-axis. Although both the first 2 series are dollar values none of these have any commonality between them and I would to plot them separately.