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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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
 
i figured it out, thanks Andy!

Jason said:
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
Click to expand...
 
Back
Top