| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Goal line or target line to Excell 2007 Chart | Charts and Charting in Excel | |||
| How do I convert a line chart to a vertical line chart in Excel | Charts and Charting in Excel | |||
| Problem adding vertical marker line to line chart | Charts and Charting in Excel | |||
| How to change bar to line in line-column on 2 axes chart in Excel2 | Charts and Charting in Excel | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
Linear Mode
