Insert Table in Preformatted Chart

J

Joseph M. Yonek

I have a chart that I have developed that I use for reporting.

The chart is updated automatically with the necessary information.

I would like to insert unrelated data on the chart in the form of a small
table with a link to the information in the workbook as an object on top of
a corner of the chart.

Is there some way for me to do that?

Thanks.
Joe
 
P

Peter Atherton

Joseph

Create two charts for the data and resize the small chart
and position it inside the other.

Select both charts. Select one, Hold ctr and select other.
The on the Drawing Toolbar menu select Group.

Regards
Peter
 
D

Debra Dalgleish

You can paste a picture of the data onto the chart, but it won't be linked:

Select the cells that you want to display in the corner of the chart
Choose Edit>Copy
Select the chart
Hold the Shift key, then choose Edit>Paste Picture
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top