Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / January 2008

Tip: Looking for answers? Try searching our database.

Rolling 12 month data charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AndreaB - 30 Jan 2008 17:41 GMT
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
Jon Peltier - 30 Jan 2008 20:23 GMT
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
_______

>I was wondering if someone could give me an example to help me get my
> head around the best way to do this.
[quoted text clipped - 27 lines]
>
> Thanks in advance for any thoughts or suggestions.  ~andrea
AndreaB - 31 Jan 2008 18:29 GMT
I will give that example a try.  Thanks again! ~andrea
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.