Dynamic chart update

  • Thread starter Thread starter Dreamstar_1961
  • Start date Start date
D

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
 
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)
 
Back
Top