how do I plot two sets of data in the same graph?

's Computer Specifications

I would like to plot shipment unit growth as a bar chart and yearly market
growth as a line chart on the same graph. What is the best way to do that?

Thanks

's Computer Specifications

Plot your two data series in a column chart. Then right-click one of the
bars and choose Chart Type from the popup menu. Select a line chart.

It's not terribly intuitive, but that's how you combine two chart types --
simply apply the other chart type to one of the series.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

"olliesf" <(E-Mail Removed)> wrote in message
news:23E4091E-2AF3-4B4E-BEF9-(E-Mail Removed)...
> I would like to plot shipment unit growth as a bar chart and yearly market
> growth as a line chart on the same graph. What is the best way to do that?
>
> Thanks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple data sets on the same graph	Doug	Microsoft Excel Programming	0	17th Dec 2009 10:17 PM
Excel graph 3 sets of data. 2 sets as lines 1 as column?	AndyN	Microsoft Excel Charting	2	11th Jul 2008 01:18 PM
show 3 sets of data per data point in a scatter plot	=?Utf-8?B?TWFyaWU=?=	Microsoft Excel Charting	6	19th May 2008 09:38 PM
multiple scatter graphes how to plot 3 sets of data for x y on th.	=?Utf-8?B?ZnJhbmNlcw==?=	Microsoft Excel Charting	2	29th Nov 2004 08:22 PM
How can I plot multiple data sets in a stacked bar chart?	=?Utf-8?B?SmVmZiBCZWNrZXI=?=	Microsoft Excel Charting	1	13th Sep 2004 01:27 AM