Line & Bar on Same Chart?

[Matt]

I have two sets of data - one set I would like to plot as a line plot,
the other as a bar plot. Is there a way to put both of these on the
same graph?

 

[jangles]

I am interested in knowing how to do this too. Is the line called a trend
line? Help in Excel says to add a trendline, you should choose "Add trend
line" from the Chart menu. There is chart tool bar and chart options, but I
don't know where the CHART MENU is?

 

[john]

just create a bar chart using all the data and then right click on the part
of the chart you want to change to a line and select chart type from the menu
and chane to a line chart.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Ineedhelp!]

When I tried this, both data series changed to a line graph.

 

[Jon Peltier]

You have to specifically select the series you want to change. If more
series changed, then some other part of the chart was selected.

- Jon