|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 27th, 2008, 10:45 AM
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
September 27th, 2008, 11:55 AM
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
September 27th, 2008, 12:15 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
