how do i make a chart with two seperate lines of data?

hi

i have a historical sales chart from Mar 2003 to present that i'm trying to
graph.

however, excel is making me keep the data in one straight line

if i try to seperate it into two rows, it adds another bit to the chart

how do i graph sales using two seperate lines of data?

Hi,

This is best done in 2 steps. Create the chart with the first set of
data. Then use the Source Data dialog to reselect the 2 data ranges,
using the CTRL key to select the 2 separate ranges.

So for data that is in the range A1:E1 continued in A2:E2 you would end
up with a series formula like this,

=SERIES(,,(Sheet1!$A$1:$E$1,Sheet1!$A$2:$E$2),1)

Cheers
Andy

Jason wrote:
hi

i have a historical sales chart from Mar 2003 to present that i'm trying to
graph.

however, excel is making me keep the data in one straight line

if i try to seperate it into two rows, it adds another bit to the chart

how do i graph sales using two seperate lines of data?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

thanks andy

when i select the first step the source data is this
=Sheet1!$A$1:$E$2 with row 1 being years and row 2 being sales data

when i select the next data it says "reference not valid" and looks like this
=Sheet1!$A$1:$E$2+Sheet1!$A$7:$E$8

i even tried to copy and paste your formula in and it says "that function is
not valid" and highlights the SERIES in the formula

thanks for your help







"Andy Pope" wrote:

Hi,

This is best done in 2 steps. Create the chart with the first set of
data. Then use the Source Data dialog to reselect the 2 data ranges,
using the CTRL key to select the 2 separate ranges.

So for data that is in the range A1:E1 continued in A2:E2 you would end
up with a series formula like this,

=SERIES(,,(Sheet1!$A$1:$E$1,Sheet1!$A$2:$E$2),1)

Cheers
Andy

Jason wrote:
hi

i have a historical sales chart from Mar 2003 to present that i'm trying to
graph.

however, excel is making me keep the data in one straight line

if i try to seperate it into two rows, it adds another bit to the chart

how do i graph sales using two seperate lines of data?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

i figured it out, thanks Andy!

"Jason" wrote:

thanks andy

when i select the first step the source data is this
=Sheet1!$A$1:$E$2 with row 1 being years and row 2 being sales data

when i select the next data it says "reference not valid" and looks like this
=Sheet1!$A$1:$E$2+Sheet1!$A$7:$E$8

i even tried to copy and paste your formula in and it says "that function is
not valid" and highlights the SERIES in the formula

thanks for your help







"Andy Pope" wrote:

Hi,

This is best done in 2 steps. Create the chart with the first set of
data. Then use the Source Data dialog to reselect the 2 data ranges,
using the CTRL key to select the 2 separate ranges.

So for data that is in the range A1:E1 continued in A2:E2 you would end
up with a series formula like this,

=SERIES(,,(Sheet1!$A$1:$E$1,Sheet1!$A$2:$E$2),1)

Cheers
Andy

Jason wrote:
hi

i have a historical sales chart from Mar 2003 to present that i'm trying to
graph.

however, excel is making me keep the data in one straight line

if i try to seperate it into two rows, it adds another bit to the chart

how do i graph sales using two seperate lines of data?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info