How to Insert a table into an excel chart

[Mike B]

After having created my excel chart(graph), I want to add an additional text
box which is summary table which exists in the worksheet. How do I do this?

[Jon Peltier]

Is the summary textbox one cell of data, or multiple:

1 cell: select the chart, create a textbox, select the textbox, type = in
the formula bar, then click on the cell and press Enter. (Easier: select the
chart, type = in the formula bar, click on the cell, press Enter.)

Multi-cell: Select the range, click on the camera tool button, then click
where you want the dynamic picture to appear.

To access the camera tool, go to Tools > Customize > Commands tab, select
Tools in the list on the left, and drag the Camera icon from the list on the
right to a convenient place in your toolbars.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Mike B" <Mike B@discussions.microsoft.com> wrote in message
news:90CC9466-B0DD-448B-B2BF-867B164D7FBE@microsoft.com...
> After having created my excel chart(graph), I want to add an additional
> text
> box which is summary table which exists in the worksheet. How do I do
> this?

[Mike B]

Jon,

Thanks for your response. For the multiple cell case. I do not want to "take
a picture" each time the table values change. I would like to have a
"dynamic" update capability, so that when the table values change, they are
automatically updated on the excel chart.

Mike B

"Jon Peltier" wrote:

> Is the summary textbox one cell of data, or multiple:
>
> 1 cell: select the chart, create a textbox, select the textbox, type = in
> the formula bar, then click on the cell and press Enter. (Easier: select the
> chart, type = in the formula bar, click on the cell, press Enter.)
>
> Multi-cell: Select the range, click on the camera tool button, then click
> where you want the dynamic picture to appear.
>
> To access the camera tool, go to Tools > Customize > Commands tab, select
> Tools in the list on the left, and drag the Camera icon from the list on the
> right to a convenient place in your toolbars.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> "Mike B" <Mike B@discussions.microsoft.com> wrote in message
> news:90CC9466-B0DD-448B-B2BF-867B164D7FBE@microsoft.com...
> > After having created my excel chart(graph), I want to add an additional
> > text
> > box which is summary table which exists in the worksheet. How do I do
> > this?
>
>
>

[Andy Pope]

Hi Mike,

As Jon mentioned the camera tools creates a dynamic picture.
Try it and then change one of the cells and watch the picture update.

Cheers
Andy

Mike B wrote:
> Jon,
>
> Thanks for your response. For the multiple cell case. I do not want to "take
> a picture" each time the table values change. I would like to have a
> "dynamic" update capability, so that when the table values change, they are
> automatically updated on the excel chart.
>
> Mike B
>
> "Jon Peltier" wrote:
>
>
>>Is the summary textbox one cell of data, or multiple:
>>
>>1 cell: select the chart, create a textbox, select the textbox, type = in
>>the formula bar, then click on the cell and press Enter. (Easier: select the
>>chart, type = in the formula bar, click on the cell, press Enter.)
>>
>>Multi-cell: Select the range, click on the camera tool button, then click
>>where you want the dynamic picture to appear.
>>
>>To access the camera tool, go to Tools > Customize > Commands tab, select
>>Tools in the list on the left, and drag the Camera icon from the list on the
>>right to a convenient place in your toolbars.
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>Tutorials and Custom Solutions
>>http://PeltierTech.com/
>>_______
>>
>>"Mike B" <Mike B@discussions.microsoft.com> wrote in message
>>news:90CC9466-B0DD-448B-B2BF-867B164D7FBE@microsoft.com...
>>
>>>After having created my excel chart(graph), I want to add an additional
>>>text
>>>box which is summary table which exists in the worksheet. How do I do
>>>this?
>>
>>
>>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info