Like the title says...
Basically I have a spreadsheet that is updated bi-weekly or monthly. It contains a more-or-less fixed number of rows. The status of the item that each row represents changes somewhat frequently. I want to create a chart that documents this status on a bi-weekly or monthly basis. I want to be able to add new columns to the chart (for each week/month) without having to create a new column in my worksheet and without loosing the data from the previous week/month. Like I said I'd somehow like the chart to represent a 'snapshot' of the status summary and be able to add more 'snapshots' to the same chart without losing the original chart information. I hope this makes sense..
Hello TS,
welcome to the forum. If you do not want to add new columns to your data, then the only recommendation I have is to copy the chart and paste it as a graphic. Otherwise, your chart will change as the data changes.
It would not be a big effort to create a table on a separate tab, where a history of data is being kept, and which can be populated with a macro at the click of a button, to add new columns for the data. Then, a dynamic chart can be created off that data, showing historic versions of the data.
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
Reply With Quote
Bookmarks