Line and Bar on same chart

[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

 

[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

 

[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