controlling copied cells as picture

penfold1992

Registered User.
Local time
Today, 17:03
Joined
Nov 22, 2012
Messages
169
I dont know what the best way is to do this but ill tell you what im looking for:

I have a graph and id like to put a table of statistics to the side of the graph (in the default location of the legend).
The best way I have thought of doing it is to leave some space for the table on the right hand side for the table... copy the table from a range and paste as a picture on the graph. (selecting the graph, paste as picture)
once i have the image, i can move it where id like to put the table and then when i copy the graph ill get the graph and the table together (the graph + table will end up going on a presentation as well as a few other documents)

when i tried to set up a macro for it... i could copy and paste the range of cells on a graph but i was unable to move it.

does anyone have a solution?
 

Users who are viewing this thread

Back
Top Bottom