Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 27th 08, 07:33 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 14
Default Dynamic chart - series label problem

I have successfully created some dynamic charts using articles referred to
here, but am struggling with one problem. The sheet is set up so that I
enter an EndDate and the StartDate is calculated from this (21 weeks back) so
I am plotting 21 pieces of data (weekly entries of various parameters). If I
choose an EndDate that is several weeks back from the latest date entered the
data plots are adjusted correctly but the x-values labels always show the
last 21 weeks of dates and therefore do not change with the data. I must be
missing something here - any suggestions would be most welcome.
--
pignick

  #2   Report Post  
Old May 27th 08, 09:33 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Dynamic chart - series label problem

Hi,

Sounds like you need to apply the same changes to your named range for
Labels as you have for the data one.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"pignick" wrote in message
...
I have successfully created some dynamic charts using articles referred to
here, but am struggling with one problem. The sheet is set up so that I
enter an EndDate and the StartDate is calculated from this (21 weeks back)
so
I am plotting 21 pieces of data (weekly entries of various parameters).
If I
choose an EndDate that is several weeks back from the latest date entered
the
data plots are adjusted correctly but the x-values labels always show the
last 21 weeks of dates and therefore do not change with the data. I must
be
missing something here - any suggestions would be most welcome.
--
pignick


  #3   Report Post  
Old May 27th 08, 07:54 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 14
Default Dynamic chart - series label problem

Thanks Andy - that has certainly pointed me in the right direction. Although
I had named ranges set up for the labels some of them were worksheet specific
and some were available in the whole workbook and presumably one takes
precedence over the other. I now need to get my head around that issue - if
I can't find the answer to that in the help files or other posts, or simply
by trial and error I may be back again. Cheers.
--
pignick


"Andy Pope" wrote:

Hi,

Sounds like you need to apply the same changes to your named range for
Labels as you have for the data one.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"pignick" wrote in message
...
I have successfully created some dynamic charts using articles referred to
here, but am struggling with one problem. The sheet is set up so that I
enter an EndDate and the StartDate is calculated from this (21 weeks back)
so
I am plotting 21 pieces of data (weekly entries of various parameters).
If I
choose an EndDate that is several weeks back from the latest date entered
the
data plots are adjusted correctly but the x-values labels always show the
last 21 weeks of dates and therefore do not change with the data. I must
be
missing something here - any suggestions would be most welcome.
--
pignick





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
Addional Data Series on Dynamic Chart bugsyb6 Charts and Charting in Excel 2 May 27th 08 03:45 PM
Data series label in Stacked Chart Connie Charts and Charting in Excel 0 March 13th 07 08:12 AM
Dynamic series for chart Jose Lopes Charts and Charting in Excel 0 March 27th 06 07:58 PM
Label an average line in a dynamic chart John Cordes Charts and Charting in Excel 3 June 17th 05 09:42 AM
Dynamic series in Chart Jeff Charts and Charting in Excel 2 February 24th 05 12:54 PM


All times are GMT +1. The time now is 01:00 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017