Hi All,
I have a very basic question that has been driving me crazy.
I have 100s of data sheets that I need to create similar graphs for.
I would like to create a graph on the first sheet and then paste the second sheet such that the graph would use the numbers from sheet 2 instead of sheet 1. I have done this in the past but its been a while. I am not sure if they removed this ability in Excel 2013 or am I just missing the way to do it? Every time I try pasting, it just pastes the same graph with its original numbers. When I try paste special, I only get different image options.
Please help.
Thanks in advance.
Mac
Bookmarks