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

[Guest]

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]

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

 

[Guest]

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

 

[Guest]

i figured it out, thanks Andy!

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