Adding a table to a chart

[Steve]

Hello everyone,

I am trying to insert a text table next to an XY scatter
chart axis. The table should update with its linked
counterpart in the spreadsheet.

I could put every cell in separately, but I was hoping
that someone has a better way to include a set of cells
in one shot.

Thanks for any information!

Steve

 

[Jon Peltier]

Steve -

Does it have to go IN the chart? Why not in the cells next to the chart.
You could copy the data from wherever it is, then use Paste Special from
the Edit menu, using the Paste Link option.

You can't even get a Data Table in an XY Scatter chart, so I won't go
into my usual diatribe - I mean _ discussion about them. Are you putting
textboxes into the chart??

You could copy the range as a picture (hold Shift while selecting Copy
Picture from the Edit menu) and put it into the chart, but that's not
dynamic. You could also use the Camera tool (you need to add the button:
Tools menu > Customize > Commands tab, select Tools in the left list and
scroll down to Camera on the right, drag the icon to a convenient
location). But it's hard to put the dynamic picture into the chart, it
wants to float over it independently. I managed to put the picture into
the chart itself (I can do anything), which led to corruption of the
worksheet (I can't do anything).

- Jon

 

[Tushar Mehta]

See the Excel/Tutorials/Custom Chart Table page of my web site for an
idea or two.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

Thanks a lot! Your websites are great and I added them to
my favorites! I probably will be a frequent browser.
Keep up the excellent work!

Steve