1 Column 2 Line Graph

[KW]

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

 

[jdee]

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]

JDEE.

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

KW

 

[jdee]

Hope you were able to accomplish what you wanted. You are welcome. J.Dee