Charts - Setting Data Area as a Variable



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


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question