Line and Bar on same chart

D

Dave

Any way to plot line data and bar data on the same chart?
For example, chart showing fuel tank cumulative gallons plus showing individual fills as bars, both vs. date

Date Fill Cumulative
Jan 100 100
Mar 250 350
Jun 175 525

Thx
Dave
Office(Excel) 2003
I'll try this in HTML
 
B

Bernard Liengme

Select all the data and make a Column chart
You will get two columns side by side
On the chart, right click on one of the columns and select "Chart Type"; now select Line type for this data series
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP
Any way to plot line data and bar data on the same chart?
For example, chart showing fuel tank cumulative gallons plus showing individual fills as bars, both vs. date

Date Fill Cumulative
Jan 100 100
Mar 250 350
Jun 175 525

Thx
Dave
Office(Excel) 2003
I'll try this in HTML
 
D

Dave

Right on Bernard !
Thank you very much
Dave

Select all the data and make a Column chart
You will get two columns side by side
On the chart, right click on one of the columns and select "Chart Type"; now
select Line type for this data series
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP
Any way to plot line data and bar data on the same chart?
For example, chart showing fuel tank cumulative gallons plus showing
individual fills as bars, both vs. date

Date Fill Cumulative
Jan 100 100
Mar 250 350
Jun 175 525

Thx
Dave
Office(Excel) 2003
I'll try this in HTML
 

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

Cumulative line on bar chart 1
Combine 2 Charts 2007 Excel 1
Bar chart by month 1
Formulas and Cumulative Values on a Line Chart 1
Charting a line and a bar on the same chart 1
3D stacked bar and line chart on same graph 2
How to set the bar with same X-axis value in same colour? 1
Bar and Line plots on the same chart 2

Top