LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default 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
 
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
Rolling 13 Month Charts Aurora Charts and Charting in Excel 1 January 17th 08 03:12 PM
12 month Rolling Total Need Help Excel Worksheet Functions 0 September 22nd 06 03:19 PM
rolling 12 month average gevans Excel Worksheet Functions 5 February 21st 06 01:09 PM
How do I set up 12-month rolling month cells in excel? jbh Excel Discussion (Misc queries) 2 November 30th 05 08:12 PM
3 month rolling chart Shanin Charts and Charting in Excel 4 September 2nd 05 06:40 PM


All times are GMT +1. The time now is 08:03 AM.

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"