I have created a chart in Excel so I can use comments like pop-up/hover text
boxes to describe the elements on the chart. Now I want to change the
appearance of the comment marker. Can you help me do that?

By "Chart" do you mean a graphical chart?

Is this chart on the sheet or is it a separate Chart Sheet?

How did you create the Comments on the chart?


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 14:56:01 -0800, Jo wrote:

I have created a chart in Excel so I can use comments like pop-up/hover text
boxes to describe the elements on the chart. Now I want to change the
appearance of the comment marker. Can you help me do that?

Sorry, I shouldn't have used the word "chart". It's only a worksheet (but it
won't be used as a spreadsheet). I have inserted hidden comments and
formatted them as large text boxes.

"Gord Dibben" wrote:

By "Chart" do you mean a graphical chart?

Is this chart on the sheet or is it a separate Chart Sheet?

How did you create the Comments on the chart?


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 14:56:01 -0800, Jo wrote:

I have created a chart in Excel so I can use comments like pop-up/hover text
boxes to describe the elements on the chart. Now I want to change the
appearance of the comment marker. Can you help me do that?

How did you insert "hidden" comments and format them as large text boxes?

Do you mean you just inserted a Comment in a cell using InsertComment and
entered text in that Comment?

The red triangle in top right corner of the cell indicating it has a Comment
cannot be changed to another color.

If you don't like the color or don't want to see the marker, you could use a
Data Validation Input Message instead of a Comment.

Only problem with that method is you have to select the cell to see the message.

Or you could use the drawing toolbar to place a colored shape over the red
marker.

Make sure to set its properties to resize and move with cells.


Gord


On Sun, 6 Jan 2008 15:36:03 -0800, Jo wrote:

Sorry, I shouldn't have used the word "chart". It's only a worksheet (but it
won't be used as a spreadsheet). I have inserted hidden comments and
formatted them as large text boxes.

"Gord Dibben" wrote:

By "Chart" do you mean a graphical chart?

Is this chart on the sheet or is it a separate Chart Sheet?

How did you create the Comments on the chart?


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 14:56:01 -0800, Jo wrote:

I have created a chart in Excel so I can use comments like pop-up/hover text
boxes to describe the elements on the chart. Now I want to change the
appearance of the comment marker. Can you help me do that?

Thanks Gord. The colour of the marker did actually change when I
reformatted the fill colour of the comment box (corresponding colour). I
like your idea of hiding it with a drawing object, given it's not able to be
individually formatted. Thanks for your help.

"Gord Dibben" wrote:

How did you insert "hidden" comments and format them as large text boxes?

Do you mean you just inserted a Comment in a cell using InsertComment and
entered text in that Comment?

The red triangle in top right corner of the cell indicating it has a Comment
cannot be changed to another color.

If you don't like the color or don't want to see the marker, you could use a
Data Validation Input Message instead of a Comment.

Only problem with that method is you have to select the cell to see the message.

Or you could use the drawing toolbar to place a colored shape over the red
marker.

Make sure to set its properties to resize and move with cells.


Gord


On Sun, 6 Jan 2008 15:36:03 -0800, Jo wrote:

Sorry, I shouldn't have used the word "chart". It's only a worksheet (but it
won't be used as a spreadsheet). I have inserted hidden comments and
formatted them as large text boxes.

"Gord Dibben" wrote:

By "Chart" do you mean a graphical chart?

Is this chart on the sheet or is it a separate Chart Sheet?

How did you create the Comments on the chart?


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 14:56:01 -0800, Jo wrote:

I have created a chart in Excel so I can use comments like pop-up/hover text
boxes to describe the elements on the chart. Now I want to change the
appearance of the comment marker. Can you help me do that?

I don't understand this statement.............

"The colour of the marker did actually change when I
reformatted the fill colour of the comment box (corresponding colour)"

but happy to hear you're satisfied.


Gord

On Sun, 6 Jan 2008 16:12:01 -0800, Jo wrote:


Thanks Gord. The colour of the marker did actually change when I
reformatted the fill colour of the comment box (corresponding colour). I
like your idea of hiding it with a drawing object, given it's not able to be
individually formatted. Thanks for your help.

"Gord Dibben" wrote:

How did you insert "hidden" comments and format them as large text boxes?

Do you mean you just inserted a Comment in a cell using InsertComment and
entered text in that Comment?

The red triangle in top right corner of the cell indicating it has a Comment
cannot be changed to another color.

If you don't like the color or don't want to see the marker, you could use a
Data Validation Input Message instead of a Comment.

Only problem with that method is you have to select the cell to see the message.

Or you could use the drawing toolbar to place a colored shape over the red
marker.

Make sure to set its properties to resize and move with cells.


Gord


On Sun, 6 Jan 2008 15:36:03 -0800, Jo wrote:

Sorry, I shouldn't have used the word "chart". It's only a worksheet (but it
won't be used as a spreadsheet). I have inserted hidden comments and
formatted them as large text boxes.

"Gord Dibben" wrote:

By "Chart" do you mean a graphical chart?

Is this chart on the sheet or is it a separate Chart Sheet?

How did you create the Comments on the chart?


Gord Dibben MS Excel MVP

On Sun, 6 Jan 2008 14:56:01 -0800, Jo wrote:

I have created a chart in Excel so I can use comments like pop-up/hover text
boxes to describe the elements on the chart. Now I want to change the
appearance of the comment marker. Can you help me do that?