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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bar and Line plots on the same chart 2
multiple series bar and line chart 2
Odd chart type needed 2
Line and Bar on same chart 2
Seemingly random plot area drift? 2
Line Chart & Bar Chart Combined 2
how do i create a chart with 4 sets of data? 3
How do 1 bar & 2 line series over the correct date? 1

Back
Top