Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i need to create a chart from data from one workbook in another wo | Excel Discussion (Misc queries) | |||
Data labels: Making the value currency & use % in a chart? | Charts and Charting in Excel | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
merge/extract data from identical worksheets in a workbook | Excel Discussion (Misc queries) | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) |