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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks