I have a range of data on a worksheet that is automatically updated on a monthly basis, a new column is added each time. I need to chart the last 4 months of the table each time a new month is added. However I have several tables of different data on my sheet one beneath the other so I have lots of different data in one column. Because of this I cannot use COUNTA in the OFFSET function.
Unfortunately I cannot attach the file as it is work-related.
Can anyone help?
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks