Dynamic chart update
 

Is it possable to have a Dynamic scatter chart start clean at the first day
of the month, these are to be charts that when printed only show the current
month, so with the start of the month it's to be a blank chart, if able to do
it how do we go about it.

Thanks

Dynamic chart update
 

Assuming the dates are in say B1:AF1, and the data is in B2:AF2, create a
dynamic named range of say rngData and a RefersTo of

=OFFSET(Sheet1!$B$2,,,1,MAX(IF((YEAR(Sheet1!$B$1:$ AF$1)=YEAR(TODAY()))*(MONTH(Sheet1!$B$1:$AF$1)=MON TH(TODAY()))*(DAY(Sheet1!$B$1:$AF$1)<=DAY(TODAY()) ),COLUMN(Sheet1!$B$1:$AF$1)))-1)

and a similar one for the headings, and rfefer to these range names in our
source data in the chart, =Sheet1!myData. You have to define all series, you
cannot use a total rnage name.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Dreamstar_1961" wrote in message
...
Is it possable to have a Dynamic scatter chart start clean at the first
day
of the month, these are to be charts that when printed only show the
current
month, so with the start of the month it's to be a blank chart, if able to
do
it how do we go about it.

Thanks