Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Need term for data series

I have a rolling average graph that starts Jan 2004 and is updated every
month - there is a benchmark, rolling average and than an annual
average.....my problem is that I don't think that annual is the correct word
because annual means year total and the end of line only equals 7 months.
Please help me find the right word or let me know if i'm overthinking this
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Need term for data series

Since the data is from jan 2004 to date won't that be like annual or would
year mean start date of data....not sure why i'm sooooo concerned with this
do people really examine these that close....

"Gary''s Student" wrote:

Instead of the term annual average, use the term:

average year-to-date

The listener (or reader) will then understand this is just an estimate of
the annual average, improving as the months go by.
--
Gary's Student


"naiad0018" wrote:

I have a rolling average graph that starts Jan 2004 and is updated every
month - there is a benchmark, rolling average and than an annual
average.....my problem is that I don't think that annual is the correct word
because annual means year total and the end of line only equals 7 months.
Please help me find the right word or let me know if i'm overthinking this
Thanks

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Need term for data series

If you are staring from Jan 2004, then use the term:

average inception-to-date

Correct verbiage is important because it is your primary tool to communicate
exactly what you want.
--
Gary's Student


"naiad0018" wrote:

Since the data is from jan 2004 to date won't that be like annual or would
year mean start date of data....not sure why i'm sooooo concerned with this
do people really examine these that close....

"Gary''s Student" wrote:

Instead of the term annual average, use the term:

average year-to-date

The listener (or reader) will then understand this is just an estimate of
the annual average, improving as the months go by.
--
Gary's Student


"naiad0018" wrote:

I have a rolling average graph that starts Jan 2004 and is updated every
month - there is a benchmark, rolling average and than an annual
average.....my problem is that I don't think that annual is the correct word
because annual means year total and the end of line only equals 7 months.
Please help me find the right word or let me know if i'm overthinking this
Thanks

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Need term for data series

Perfect........Thanks

"Gary''s Student" wrote:

If you are staring from Jan 2004, then use the term:

average inception-to-date

Correct verbiage is important because it is your primary tool to communicate
exactly what you want.
--
Gary's Student


"naiad0018" wrote:

Since the data is from jan 2004 to date won't that be like annual or would
year mean start date of data....not sure why i'm sooooo concerned with this
do people really examine these that close....

"Gary''s Student" wrote:

Instead of the term annual average, use the term:

average year-to-date

The listener (or reader) will then understand this is just an estimate of
the annual average, improving as the months go by.
--
Gary's Student


"naiad0018" wrote:

I have a rolling average graph that starts Jan 2004 and is updated every
month - there is a benchmark, rolling average and than an annual
average.....my problem is that I don't think that annual is the correct word
because annual means year total and the end of line only equals 7 months.
Please help me find the right word or let me know if i'm overthinking this
Thanks

Reply
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
Need term for data series Gary''s Student Excel Discussion (Misc queries) 0 August 23rd 06 12:20 AM
Trying to change ColorIndex for series settings SiriS Charts and Charting in Excel 3 March 14th 06 01:54 PM
Chart -- Source Data... -- Series dialog window Sarah Jane Charts and Charting in Excel 2 January 24th 06 10:27 AM
How to change Series order in a Combination Chart? vrk1 Charts and Charting in Excel 3 April 1st 05 07:21 AM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Charts and Charting in Excel 3 March 30th 05 06:23 PM


All times are GMT +1. The time now is 05:25 PM.

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"