Line and Bar on same chart
in [Charts]
|
From: Dave on 2 Dec 2009 16:04 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
From: Bernard Liengme on 2 Dec 2009 16:21 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" <djbahb(a)dcwis.com> wrote in message news:OjkKEM5cKHA.1648(a)TK2MSFTNGP05.phx.gbl... 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
From: Dave on 3 Dec 2009 09:19 Right on Bernard ! Thank you very much Dave "Bernard Liengme" <bliengme(a)stfx.TRUENORTH.ca> wrote in message news:OE%2317V5cKHA.2596(a)TK2MSFTNGP04.phx.gbl... 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" <djbahb(a)dcwis.com> wrote in message news:OjkKEM5cKHA.1648(a)TK2MSFTNGP05.phx.gbl... 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
|
Pages: 1 Prev: can i edit only a selected range of data in an excel chart? Next: "Dynamic" Legends |