Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ezlpo
 
Posts: n/a
Default Making a chart using data from different worksheets in a workbook.

I am trying to make a chart (line graph) that uses data from many different
worksheets.

The graph is being created to plot sales data week to week for many
different salespeople. Each week is its own worksheet.

There are around 70 sales people, but for the report I am only interested in
8-25 (but potentially all 70). Their names are listed in column A, but
because there are so many of them they are not always in the same row as they
were the week (read: worksheet) prior.

Now I know I can take the time to create a graph for each salesperson, but I
was hoping there would be an easier solution. I do not have crystal reports
(not that I would know how to use them) and I don't have any skill using the
Virtual Basic features (although I fear that for this I will need to learn
some).

Thank you in advance.


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
i need to create a chart from data from one workbook in another wo Marko30 Excel Discussion (Misc queries) 1 October 14th 05 06:15 PM
Data labels: Making the value currency & use % in a chart? AKO Charts and Charting in Excel 1 August 2nd 05 09:47 PM
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
merge/extract data from identical worksheets in a workbook Michelle K Excel Discussion (Misc queries) 5 June 21st 05 05:24 PM
Help making a chart that doesn't graph cells without data? Filtration Guy Excel Discussion (Misc queries) 0 March 22nd 05 10:21 PM


All times are GMT +1. The time now is 08:10 PM.

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

About Us

"It's about Microsoft Excel"