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?
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?