Dynamic chart update

[Dreamstar_1961]

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

 

[Bob Phillips]

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)=MONTH(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)