I have a workbook with a worksheet for each month wherein I track electricity usage. Each worksheet has rows for days of the billing period and columns to track things like KWH and to calculate values for cumulative usage, trend, cost per day, cumulative costs per day, etc.
I have a line graph that uses entries from various columns for various lines. Each month, I have recreated the line graph. I would like to be able to copy it from one month to the next and have the next month chart use that month's values; however, the graph - when pasted in the new month's worksheet - references entries from the previous month.
Is it possible to copy just the graph-defining variables and them refer to the new worksheet values?"
Failing that, is there an easier way to edit the Name Manager entries (from Formulas>Name Manager) than manually editing each entry to show the new month's worksheet reference?
I've attached my workbook to illustrate my question.
This is my first post on this forum; so if I've violated any rules or practices, please slap my hands and tell me what I've done to offend.
Bookmarks