1 Column 2 Line Graph

KW

Board Regular
Joined
Jan 25, 2005
Messages
167
Hi.

Can anyone tell me how I can create a chart with 1 series of data as a column & two further series of data showing as lines across the columns:

e.g.

Month Jan Feb Mar Apr etc
Series1 12 15 10 16 (Column)
Series2 6 3 4 6 (Line1)
Series3 4 5 1 5 (Line2)

Would appreciate any help.

KW
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

jdee

Active Member
Joined
Sep 10, 2003
Messages
276
Using chart wizard, choose column chart, creat the chart as column. Then right click on 1st set you desire as line chart, choose chart type, choose line, then do same for 2nd set you want as line chart, and end result should be 1st set as column, 2nd two sets as lines.
 

KW

Board Regular
Joined
Jan 25, 2005
Messages
167
JDEE.

It's simple when you know how. Many thanks for your help.

KW
 

jdee

Active Member
Joined
Sep 10, 2003
Messages
276
Hope you were able to accomplish what you wanted. You are welcome. J.Dee
 

Watch MrExcel Video

Forum statistics

Threads
1,122,521
Messages
5,596,652
Members
414,083
Latest member
Mrsash

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