Combination Chart Creation

Queenlinker

New Member
Joined
Oct 27, 2002
Messages
3
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
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
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?
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
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

New Member
Joined
Oct 27, 2002
Messages
3
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,224
Messages
5,594,914
Members
413,952
Latest member
JGer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top