Line & Bar on Same Chart?

  • Thread starter Thread starter Matt
  • Start date Start date
M

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?
 
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?
 
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)
 
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
 
Back
Top