Line Chart & Bar Chart Combined

K

Karen

Using Excel 2003
I have 3 series of data. I want 3 of the series to be plotted as a bar chart
and one series as a line chart. Is this possible?
Thank you, Karen
 
J

John Mansfield

Yes, Excel does allow you to build many types of combination charts. For
example, assume you already have a column chart that shows all three series.
To change one of the series to a line, first select the series in the chart.
Next, go to the standard toolbar and select Chart -> Chart Type. Finally,
select the chart that you would like to apply (line for example).

Jon Peltier provides many detailed examples of how to do so on his site . . .

http://peltiertech.com/Excel/Charts/ComboChart1.html
 
K

Karen

Thank you very much Jon! You are always very helpful.
Thanks for the great link also!
Karen
 

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

Not plot a data series in a chart but still display in data table 1
Adding a line to a bar chart 1
To plot 3 series each with 90000 data in single Line or XY chart. 4
Odd Chart Format Results 1
Chart with columns and lines 1
Assign data series to primary axis 1
User Selectable Series and Number of Series for Line Chart 2
adding trendline to plots from multiple series 1

Top