Hi all,
Excel 2007. I have a personal budget template that I use that includes some graphing of the data. Each worksheet corresponds to a month. When I copy and paste the template and the graphs to a new worksheet I have to manually update the graph data to the new worksheet. It pulls data from from the previous worksheet.
How can I change this so that the graph pulls data from the current worksheet?
Thanks,
g