Line & Bar on Same Chart?
 

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?

Line & Bar on Same Chart?
 

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?

"Matt" wrote:

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?

Line & Bar on Same Chart?
 

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)


"Matt" wrote:

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?

Line & Bar on Same Chart?
 

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

"john" wrote:

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)


"Matt" wrote:

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?

Line & Bar on Same Chart?
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ineedhelp!" wrote in message
...
When I tried this, both data series changed to a line graph.

"john" wrote:

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)


"Matt" wrote:

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?