Hi,

First column should contain the quarter/year data.
Second column should contain Intake volume for Office 1.
Third column should contain Intake volume for Office 2.
etc ...

If you put Office name in first row and start data in row 2 this will
help excel determine your data layout.

Cheers
Andy

Suzanne wrote:
Hello. I need assistance with 2 items please.
I want to create a line graph with:

X axis being a time dimension (quarter/year)
y axis being intake volue
Have a line plot for each office; qq/yy and intake

How do i have to table my data to produce the multiple lines, i'm trying to
use xy chart. Hope someone can help.

--

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