| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart - Multiple Lines
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. -- Thank you -- Suzanne. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line Chart - Multiple Lines
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line Chart - Multiple Lines
I will give it a go, thanks Andy!
-- Thank you -- Suzanne. "Andy Pope" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lines in line chart do not show up | Charts and Charting in Excel | |||
| display 1 line of multiple worksheets into multiple lines on 1 wks | Excel Worksheet Functions | |||
| I can't get any lines in my line chart | Charts and Charting in Excel | |||
| Vertical lines in a line chart | Charts and Charting in Excel | |||
| Lines missing in line chart | Charts and Charting in Excel | |||
Linear Mode
