Like a comment, can I attach a chart to a cell?

[Girl4chuckie]

As my subject indicates, I have a list of employees with adjacent columns
indicating dates of importance. These dates have comments attached to them.
What I'd like to do is in the Cell that contains the employee's name, attach
a separate excel spreadsheet. It would be for the purpose of adding a small
chart.
Has anyone been able to do anything like this?

 

[Shane Devenshire]

Hi,

You want a sheet in a cell or a chart in a cell? What do you want it to do,
open up when the user clicks it?

You can add a hyperlink to a cell which can open another file or jump to
another part of your workbook, where you might put your chart. But there
is no way to have a comment like chart which opens as you hover over a cell.

 

[Gord Dibben]

You could create the chart, copy it to Paint and save as a *.jpg

Then you can place that *.jpg into a Comment as background image.


Gord Dibben MS Excel MVP