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
|
|||
|
|||
Excel Graphs
I have 3 years of data that I want to graph. These are unit sales and price
by week. What is the best way to do this? I can get 2 years with a columns/lines but can't seem to figure out how to include that third year. |
#2
|
|||
|
|||
Excel Graphs
How are the data laid out? If you have three columns:
WeekID Sales Price XL should have no problem plotting as many rows as you have (well, subject to certain limits, none of which are anywhere near 1,000 data points and 2 series). -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I have 3 years of data that I want to graph. These are unit sales and price by week. What is the best way to do this? I can get 2 years with a columns/lines but can't seem to figure out how to include that third year. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Decimal pt changes on linked graphs | Greg A | Powerpoint | 4 | January 4th, 2006 04:06 PM |
Changing Imported Excel Graphs to Pictures in PPT | Spyder | Powerpoint | 2 | December 22nd, 2005 01:24 AM |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 07:32 PM |
Excel Range Value issue (Excel 97 Vs Excel 2003) | Keeno | General Discussion | 2 | June 13th, 2005 02:01 PM |
placing Excel graphs into Word table cells | wlotto | Charts and Charting | 1 | March 7th, 2004 05:29 AM |