Line Chart - Multiple Lines

  • Thread starter Thread starter Suzanne
  • Start date Start date
S

Suzanne

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.
 
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
 
Back
Top