Line and Bar on same chart
 

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

Line and Bar on same chart
 

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
"Dave" wrote in message ...
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

Line and Bar on same chart
 

Right on Bernard !
Thank you very much
Dave

"Bernard Liengme" wrote in message
...
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
"Dave" wrote in message
...
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