I want my chart (very small chart) to emerge when you hover over a sales
number.
As if the chart was embeded within a comment.
When you go over a cell with a comment, it opens up.
I do not want the chart or graph to be present on other pages or tabs.

You can save your chart as an image, and then format your comment box to
contain that image, but it won't update if your data updates.

Dave

url:http://www.ureader.com/msg/10296778.aspx

Your directions for embedding a chart to a comment was great.

Do you have any thoughts on how I can have a real-time chart open and close
so it would be attached to a cell?
I am flexible on was to do this, but I have an excel spreadsheet and I want
peoples sales numbers to be on the sheet but not always open large pictures.
I would like them to work very similar to the way comments pop up.

Also, would you know how I could go about making this suggestion to
Microsoft if there is not a way for this to work?

Thanks in advance for your help.


"Dave Curtis" wrote:

You can save your chart as an image, and then format your comment box to
contain that image, but it won't update if your data updates.

Dave

url:http://www.ureader.com/msg/10296778.aspx

I'm pretty sure there's no direct way to display a dynamic chart in a
Comment or similar. Even VBA code cannot track "mouse over" cells (at least
not directly) and in turn toggle visibility of a dynamic chart in the same
way Comments are displayed.

In theory VBA code could update the picture in the comment as changes are
made to the underlying chart data in cells. Quite a lot of work and possibly
mountainous to ensure all works reliably.

Not quite what you are looking for but you could make a dynamic chart
visible when you "select" a particular cell (or say a cell within a given
range of cells), then when user selects some other cell hide the chart. This
requires VBA "event" type code. Could also ensure that if user attempts to
select the visible chart the selection will revert to the cell.

If interested in the "select cell and display" approach and able to adapt
code to your own requirements post back.

Regards,
Peter T

Post back if that's
"GeneW" wrote in message
...
Your directions for embedding a chart to a comment was great.

Do you have any thoughts on how I can have a real-time chart open and
close
so it would be attached to a cell?
I am flexible on was to do this, but I have an excel spreadsheet and I
want
peoples sales numbers to be on the sheet but not always open large
pictures.
I would like them to work very similar to the way comments pop up.

Also, would you know how I could go about making this suggestion to
Microsoft if there is not a way for this to work?

Thanks in advance for your help.


"Dave Curtis" wrote:

You can save your chart as an image, and then format your comment box to
contain that image, but it won't update if your data updates.

Dave

url:http://www.ureader.com/msg/10296778.aspx

Peter-
Thanks for the feedback. Although you maybe on the right course. I think
that is WAY above my head.
I would love to be able to try what you posted, but I have NO experience in
Excel code.

Gene

"Peter T" wrote:

I'm pretty sure there's no direct way to display a dynamic chart in a
Comment or similar. Even VBA code cannot track "mouse over" cells (at least
not directly) and in turn toggle visibility of a dynamic chart in the same
way Comments are displayed.

In theory VBA code could update the picture in the comment as changes are
made to the underlying chart data in cells. Quite a lot of work and possibly
mountainous to ensure all works reliably.

Not quite what you are looking for but you could make a dynamic chart
visible when you "select" a particular cell (or say a cell within a given
range of cells), then when user selects some other cell hide the chart. This
requires VBA "event" type code. Could also ensure that if user attempts to
select the visible chart the selection will revert to the cell.

If interested in the "select cell and display" approach and able to adapt
code to your own requirements post back.

Regards,
Peter T

Post back if that's
"GeneW" wrote in message
...
Your directions for embedding a chart to a comment was great.

Do you have any thoughts on how I can have a real-time chart open and
close
so it would be attached to a cell?
I am flexible on was to do this, but I have an excel spreadsheet and I
want
peoples sales numbers to be on the sheet but not always open large
pictures.
I would like them to work very similar to the way comments pop up.

Also, would you know how I could go about making this suggestion to
Microsoft if there is not a way for this to work?

Thanks in advance for your help.


"Dave Curtis" wrote:

You can save your chart as an image, and then format your comment box to
contain that image, but it won't update if your data updates.

Dave

url:http://www.ureader.com/msg/10296778.aspx

Do your charts necessarily have to be "large" pictures? If you simplify the
chart, remove some of the labels and other excess shapes in the chart, you
might be able to show what you want with a chart a few cells wide and half a
dozen cells tall. In the extreme you could even try sparkline charts:

http://sparklines-excel.blogspot.com/
http://www.bonavistasystems.com/
http://www.bissantz.de/sparklines/

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


"GeneW" wrote in message
...
Your directions for embedding a chart to a comment was great.

Do you have any thoughts on how I can have a real-time chart open and
close
so it would be attached to a cell?
I am flexible on was to do this, but I have an excel spreadsheet and I
want
peoples sales numbers to be on the sheet but not always open large
pictures.
I would like them to work very similar to the way comments pop up.

Also, would you know how I could go about making this suggestion to
Microsoft if there is not a way for this to work?

Thanks in advance for your help.


"Dave Curtis" wrote:

You can save your chart as an image, and then format your comment box to
contain that image, but it won't update if your data updates.

Dave

url:http://www.ureader.com/msg/10296778.aspx