View Single Post
  #2   Report Post  
martincrow martincrow is offline
Banned
 
Posts: 29
Default

Quote:
Originally Posted by AllisonD View Post
Hi,

This is my first time posting here, so I hope someone can help me.

Basically what I want to do is:

I have a chart that I have made previously. My boss wants me to add a little table, that shows three columns along the top, and 2 rows on the side (total and achieved), he wants to update the information weekly, but he also wishes for the table to be placed in the chart (on the side so its a piece of extra info in the chart)

Is there any way to do this so that when he updates his little table it changes automatically in the chart? Or am I just stuck with just copy and pasting??

Please let me know if you need any further info to help you help me :)
select the chart, create a textbox, select the textbox, type = in the formula bar, then click on the cell and press Enter. Select the range, click on the camera tool button, then click where you want the dynamic picture to appear.