| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting only partial data from a large dataset
I have a large data set which I update monthly. The monthly data are in
columns -- the rows are employees. Each month their sales figures are added in the next available column. I have at least 5 years (i.e. 60 months of data). I only want to chart for selected employees their sales for 2 years but not necessarily the most 2 years. How would I go about setting this up? Currently I update the charts manually but I can't go back and look at different timeperiods. Any help will be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting only partial data from a large dataset
This is a complicated problem, but I wrote an article which may help you
through it: http://pubs.logicalexpressions.com/P...cle.asp?ID=246 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "forest8" wrote in message ... I have a large data set which I update monthly. The monthly data are in columns -- the rows are employees. Each month their sales figures are added in the next available column. I have at least 5 years (i.e. 60 months of data). I only want to chart for selected employees their sales for 2 years but not necessarily the most 2 years. How would I go about setting this up? Currently I update the charts manually but I can't go back and look at different timeperiods. Any help will be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Charting only partial data from a large dataset
This worked great. Thanks.
"Jon Peltier" wrote: This is a complicated problem, but I wrote an article which may help you through it: http://pubs.logicalexpressions.com/P...cle.asp?ID=246 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "forest8" wrote in message ... I have a large data set which I update monthly. The monthly data are in columns -- the rows are employees. Each month their sales figures are added in the next available column. I have at least 5 years (i.e. 60 months of data). I only want to chart for selected employees their sales for 2 years but not necessarily the most 2 years. How would I go about setting this up? Currently I update the charts manually but I can't go back and look at different timeperiods. Any help will be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting small and large percentages | Charts and Charting in Excel | |||
| pivot table using very large dataset | Excel Discussion (Misc queries) | |||
| Sorting dataset automatically after entering data in a row [or cel | Excel Discussion (Misc queries) | |||
| remove partial data from cell | Excel Worksheet Functions | |||
| How to calculate average from large dataset in several sheets? | Excel Worksheet Functions | |||
Linear Mode
