#1   Report Post  
Posted to microsoft.public.excel.charting
PB
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Make graphs in Excel all the same size ready to paste into Word - sub210 Charts and Charting in Excel 4 April 25th 23 11:47 AM
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
line graphs in excel karl gauss Excel Worksheet Functions 1 March 17th 05 11:55 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"