Hi All
I have a sheet with lots of graphs in with the data for each graph above each one.
I have to move the order of the data and graphs and i'm trying to find the easiest way to do it.
My question is can I move the data for each graph without having to edit the data range for each graph? ie is there a way to 'lock on' the data so wherever it is or moved to the graph will
always pick it up?
Thanks
My suggestion is to make a copy of the file, that is "Save as" the file with a different name i.e. if the file is named file 1 "Save as" file 1_2 so that you have a copy with which to experiment.
See if moving the data and the graphs on your copy (file 1_2) causes problems.
If so then utilize the instructions in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page, so that we have a better idea of what is being attempted.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks