Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Rolling 12 month data charts
I was wondering if someone could give me an example to help me get my
head around the best way to do this. I have posted before on how my charts us data tables and that I would like to change that. I need to add annotations to specific months that stay with the data point as the calendar year rolls to the next month. What I am needing is someone to help me out by giving me an example of what my chart should look like with the chart and then the data below in a similar format as the data table. I have close to 35 charts that I have to do this for and I want to make sure I start this new process in the best way possible. The data I chart is broken down into groups. Each group has about 8 measures that are charted. My data is listed in this format: Measures Group Feb-07 Mar-07 Apr-07 Individual Measures 85% 92% 85% (the percentages are what is charted) # received 22 24 22 # eligiable 26 26 26 What a really need to know is if I should keep my data on one worksheet tab or if I need to group the data with each measure. Their has to be an easier way to track this data and have it roll each month. I don't mind updating the charts to reflect the changing data, but I am not quite understand how to best get the data below the chart and have it roll each month too. Thanks in advance for any thoughts or suggestions. ~andrea |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Rolling 12 month data charts
Just keep the data in a worksheet, and let the defined names sort it out:
http://peltiertech.com/Excel/Charts/DynamicLast12.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "AndreaB" wrote in message ... I was wondering if someone could give me an example to help me get my head around the best way to do this. I have posted before on how my charts us data tables and that I would like to change that. I need to add annotations to specific months that stay with the data point as the calendar year rolls to the next month. What I am needing is someone to help me out by giving me an example of what my chart should look like with the chart and then the data below in a similar format as the data table. I have close to 35 charts that I have to do this for and I want to make sure I start this new process in the best way possible. The data I chart is broken down into groups. Each group has about 8 measures that are charted. My data is listed in this format: Measures Group Feb-07 Mar-07 Apr-07 Individual Measures 85% 92% 85% (the percentages are what is charted) # received 22 24 22 # eligiable 26 26 26 What a really need to know is if I should keep my data on one worksheet tab or if I need to group the data with each measure. Their has to be an easier way to track this data and have it roll each month. I don't mind updating the charts to reflect the changing data, but I am not quite understand how to best get the data below the chart and have it roll each month too. Thanks in advance for any thoughts or suggestions. ~andrea |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Rolling 12 month data charts
I will give that example a try. Thanks again! ~andrea
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rolling 13 Month Charts | Charts and Charting in Excel | |||
12 month Rolling Total | Excel Worksheet Functions | |||
rolling 12 month average | Excel Worksheet Functions | |||
How do I set up 12-month rolling month cells in excel? | Excel Discussion (Misc queries) | |||
3 month rolling chart | Charts and Charting in Excel |