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?

Gee, and I thought I was good with language. I inserted a comment (right
click, insert comment), formatted the comment (highlight comment frame,
format menu, comment) and changed the fill colour. Then I hid the comment
(right click, hide comment). The marker (could also be called a comment
indicator) which remains visible in the corner of the cell which has a
comment inserted, automatically changed to the same colour as the comment
fill colour.

"Gord Dibben" wrote:

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?

That is what I thought you meant, but in my Excel 2003 it does not change the
red triangle indicator/marker to the color of the Comment fill color.

Stays red.

What version of Excel are you running?


Gord

On Mon, 7 Jan 2008 13:50:03 -0800, Jo wrote:


Gee, and I thought I was good with language. I inserted a comment (right
click, insert comment), formatted the comment (highlight comment frame,
format menu, comment) and changed the fill colour. Then I hid the comment
(right click, hide comment). The marker (could also be called a comment
indicator) which remains visible in the corner of the cell which has a
comment inserted, automatically changed to the same colour as the comment
fill colour.

"Gord Dibben" wrote:

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?

2000. I've noticed the newer versions of Microsoft programs (and Windows)
sometimes seem to have less features in some functions. Thanks for your help
anyway. I appreciate you clever people out there.

By the way, when I put a drawing object of the marker it stopped the comment
box popping up....

"Gord Dibben" wrote:

That is what I thought you meant, but in my Excel 2003 it does not change the
red triangle indicator/marker to the color of the Comment fill color.

Stays red.

What version of Excel are you running?


Gord

On Mon, 7 Jan 2008 13:50:03 -0800, Jo wrote:


Gee, and I thought I was good with language. I inserted a comment (right
click, insert comment), formatted the comment (highlight comment frame,
format menu, comment) and changed the fill colour. Then I hid the comment
(right click, hide comment). The marker (could also be called a comment
indicator) which remains visible in the corner of the cell which has a
comment inserted, automatically changed to the same colour as the comment
fill colour.

"Gord Dibben" wrote:

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?