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