I have a set of monthly financial reports and associated charts.
I need all the charts to show data just up to the current month.
Up to now I have had to manually adjust the data area chart by chart at the
end of each month as I move the model from one month to the next.
What I need is to simply adjust one cell to state the new month number and
this will adjust the data areas for all the charts.
I have been experimenting with the OFFSET function plugged into the chart
data range but it seems that this is not allowed.
Can someone suggest an 'easy' way around this problem
--
JohnG