Hello All,

I am trying to manipulate the "insert comment" capability in excel. Instead
of having text appear in the comment box when the cell is selected, I would
like a pie chart to appear. I know that it is possible to insert a picture
into this comment box, but I need to find a way to insert the chart without
pasting it as a picture. That is, the chart needs to remain dynamic. I would
appreciate any input anyone might have on how I might accomplish this.
Thanks in advance,

Ashleigh

Ashleigh -

Hmm, I didn't know you could insert a picture into a comment. I know
what I'll be playing with later.

Use the methodology shown by John Walkenbach's example, How to Put a
Chart Onto a User Form (look under Developer Tips at http://j-walk.com).
He shows how to save a chart as a gif file, then load the gif file
into a picture control on a form. What you might do is copy the chart
as a picture, and paste it in the comment. I'm not sure how you'd make
it dynamic, though. I couldn't find a Comment_Show event you could do
this in response to.

But you could set up a Worksheet_SelectionChange event procedure, so if
you click in a new cell (not just mouse over it like a comment), you can
have the macro retrieve or draw a chart, and temporarily show it.

Another trick I just thought of is to display the chart window. The
chart itself has to be on the active sheet, but anywhere on it. You can
run this macro from a Selection Change event, and it will open the chart
window for the indicated chart, and line it up with the active cell:

Sub ShowChartWindow()
Dim atop As Single
Dim aleft As Single
atop = ActiveCell.top
aleft = ActiveCell.left
Worksheets(1).ChartObjects(1).Activate
ActiveChart.ShowWindow = True
ActiveWindow.top = atop
ActiveWindow.left = aleft
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Ashleigh K. wrote:
Hello All,

I am trying to manipulate the "insert comment" capability in excel. Instead
of having text appear in the comment box when the cell is selected, I would
like a pie chart to appear. I know that it is possible to insert a picture
into this comment box, but I need to find a way to insert the chart without
pasting it as a picture. That is, the chart needs to remain dynamic. I would
appreciate any input anyone might have on how I might accomplish this.
Thanks in advance,

Ashleigh

Jon, there are instructions here for adding a picture to a comment:

http://www.contextures.com/xlcomments02.html#Picture

I don't know how you'd make it dynamic, but you could use a macro to
save a gif file of the chart, and automatically update it after any
changes to the data.

Jon Peltier wrote:
Ashleigh -

Hmm, I didn't know you could insert a picture into a comment. I know
what I'll be playing with later.

Use the methodology shown by John Walkenbach's example, How to Put a
Chart Onto a User Form (look under Developer Tips at http://j-walk.com).
He shows how to save a chart as a gif file, then load the gif file into
a picture control on a form. What you might do is copy the chart as a
picture, and paste it in the comment. I'm not sure how you'd make it
dynamic, though. I couldn't find a Comment_Show event you could do this
in response to.

But you could set up a Worksheet_SelectionChange event procedure, so if
you click in a new cell (not just mouse over it like a comment), you can
have the macro retrieve or draw a chart, and temporarily show it.

Another trick I just thought of is to display the chart window. The
chart itself has to be on the active sheet, but anywhere on it. You can
run this macro from a Selection Change event, and it will open the chart
window for the indicated chart, and line it up with the active cell:

Sub ShowChartWindow()
Dim atop As Single
Dim aleft As Single
atop = ActiveCell.top
aleft = ActiveCell.left
Worksheets(1).ChartObjects(1).Activate
ActiveChart.ShowWindow = True
ActiveWindow.top = atop
ActiveWindow.left = aleft
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Ashleigh K. wrote:

Hello All,

I am trying to manipulate the "insert comment" capability in excel.
Instead
of having text appear in the comment box when the cell is selected, I
would
like a pie chart to appear. I know that it is possible to insert a
picture
into this comment box, but I need to find a way to insert the chart
without
pasting it as a picture. That is, the chart needs to remain dynamic. I
would
appreciate any input anyone might have on how I might accomplish this.
Thanks in advance,

Ashleigh





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Deb -

I thought the Chart Window approach was kind of cool.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Debra Dalgleish wrote:
Jon, there are instructions here for adding a picture to a comment:

http://www.contextures.com/xlcomments02.html#Picture

I don't know how you'd make it dynamic, but you could use a macro to
save a gif file of the chart, and automatically update it after any
changes to the data.

Jon Peltier wrote:

Ashleigh -

Hmm, I didn't know you could insert a picture into a comment. I know
what I'll be playing with later.

Use the methodology shown by John Walkenbach's example, How to Put a
Chart Onto a User Form (look under Developer Tips at
http://j-walk.com). He shows how to save a chart as a gif file, then
load the gif file into a picture control on a form. What you might do
is copy the chart as a picture, and paste it in the comment. I'm not
sure how you'd make it dynamic, though. I couldn't find a
Comment_Show event you could do this in response to.

But you could set up a Worksheet_SelectionChange event procedure, so
if you click in a new cell (not just mouse over it like a comment),
you can have the macro retrieve or draw a chart, and temporarily show it.

Another trick I just thought of is to display the chart window. The
chart itself has to be on the active sheet, but anywhere on it. You
can run this macro from a Selection Change event, and it will open the
chart window for the indicated chart, and line it up with the active
cell:

Sub ShowChartWindow()
Dim atop As Single
Dim aleft As Single
atop = ActiveCell.top
aleft = ActiveCell.left
Worksheets(1).ChartObjects(1).Activate
ActiveChart.ShowWindow = True
ActiveWindow.top = atop
ActiveWindow.left = aleft
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Ashleigh K. wrote:

Hello All,

I am trying to manipulate the "insert comment" capability in excel.
Instead
of having text appear in the comment box when the cell is selected, I
would
like a pie chart to appear. I know that it is possible to insert a
picture
into this comment box, but I need to find a way to insert the chart
without
pasting it as a picture. That is, the chart needs to remain dynamic.
I would
appreciate any input anyone might have on how I might accomplish this.
Thanks in advance,

Ashleigh

Who are you to cut into my quality goofing off time?


Debra Dalgleish wrote:
Jon,
Yes, the Chart Window approach definitely is cool!

I was just responding to the first sentence of your post -- "I didn't
know you could insert a picture into a comment" -- to save you some
experimenting time.

Deb

Jon Peltier wrote:

Deb -

I thought the Chart Window approach was kind of cool.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Debra Dalgleish wrote:

Jon, there are instructions here for adding a picture to a comment:

http://www.contextures.com/xlcomments02.html#Picture

I don't know how you'd make it dynamic, but you could use a macro to
save a gif file of the chart, and automatically update it after any
changes to the data.

Jon Peltier wrote:

Ashleigh -

Hmm, I didn't know you could insert a picture into a comment. I
know what I'll be playing with later.

Use the methodology shown by John Walkenbach's example, How to Put a
Chart Onto a User Form (look under Developer Tips at
http://j-walk.com). He shows how to save a chart as a gif file,
then load the gif file into a picture control on a form. What you
might do is copy the chart as a picture, and paste it in the
comment. I'm not sure how you'd make it dynamic, though. I
couldn't find a Comment_Show event you could do this in response to.

But you could set up a Worksheet_SelectionChange event procedure, so
if you click in a new cell (not just mouse over it like a comment),
you can have the macro retrieve or draw a chart, and temporarily
show it.

Another trick I just thought of is to display the chart window. The
chart itself has to be on the active sheet, but anywhere on it. You
can run this macro from a Selection Change event, and it will open
the chart window for the indicated chart, and line it up with the
active cell:

Sub ShowChartWindow()
Dim atop As Single
Dim aleft As Single
atop = ActiveCell.top
aleft = ActiveCell.left
Worksheets(1).ChartObjects(1).Activate
ActiveChart.ShowWindow = True
ActiveWindow.top = atop
ActiveWindow.left = aleft
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Ashleigh K. wrote:

Hello All,

I am trying to manipulate the "insert comment" capability in excel.
Instead
of having text appear in the comment box when the cell is selected,
I would
like a pie chart to appear. I know that it is possible to insert a
picture
into this comment box, but I need to find a way to insert the chart
without
pasting it as a picture. That is, the chart needs to remain
dynamic. I would
appreciate any input anyone might have on how I might accomplish this.
Thanks in advance,

Ashleigh

Sorry! I don't know what I was thinking. I'll bet you could spend lots
of time goofing off he

http://www.geocities.com/jonpeltier/...rts/index.html

and learn a thing or two about charts!

Jon Peltier wrote:
Who are you to cut into my quality goofing off time?


Debra Dalgleish wrote:

Jon,
Yes, the Chart Window approach definitely is cool!

I was just responding to the first sentence of your post -- "I didn't
know you could insert a picture into a comment" -- to save you some
experimenting time.

Deb

Jon Peltier wrote:

Deb -

I thought the Chart Window approach was kind of cool.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Debra Dalgleish wrote:

Jon, there are instructions here for adding a picture to a comment:

http://www.contextures.com/xlcomments02.html#Picture

I don't know how you'd make it dynamic, but you could use a macro to
save a gif file of the chart, and automatically update it after any
changes to the data.

Jon Peltier wrote:

Ashleigh -

Hmm, I didn't know you could insert a picture into a comment. I
know what I'll be playing with later.

Use the methodology shown by John Walkenbach's example, How to Put
a Chart Onto a User Form (look under Developer Tips at
http://j-walk.com). He shows how to save a chart as a gif file,
then load the gif file into a picture control on a form. What you
might do is copy the chart as a picture, and paste it in the
comment. I'm not sure how you'd make it dynamic, though. I
couldn't find a Comment_Show event you could do this in response to.

But you could set up a Worksheet_SelectionChange event procedure,
so if you click in a new cell (not just mouse over it like a
comment), you can have the macro retrieve or draw a chart, and
temporarily show it.

Another trick I just thought of is to display the chart window.
The chart itself has to be on the active sheet, but anywhere on
it. You can run this macro from a Selection Change event, and it
will open the chart window for the indicated chart, and line it up
with the active cell:

Sub ShowChartWindow()
Dim atop As Single
Dim aleft As Single
atop = ActiveCell.top
aleft = ActiveCell.left
Worksheets(1).ChartObjects(1).Activate
ActiveChart.ShowWindow = True
ActiveWindow.top = atop
ActiveWindow.left = aleft
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Ashleigh K. wrote:

Hello All,

I am trying to manipulate the "insert comment" capability in
excel. Instead
of having text appear in the comment box when the cell is
selected, I would
like a pie chart to appear. I know that it is possible to insert a
picture
into this comment box, but I need to find a way to insert the
chart without
pasting it as a picture. That is, the chart needs to remain
dynamic. I would
appreciate any input anyone might have on how I might accomplish
this.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html