How do I display spreadsheet comments in a chart?

  • Thread starter Thread starter GTYT
  • Start date Start date
G

GTYT

If I insert a comment into a spreadsheet, how can I show that same comments
in any chart/s I create from that spreadsheet data?
 
If you mean by comment just some text you have in a cell, no problem, but if
you mean a comment inserted using Insert, Comment, for that you will need VBA.

In the first case, where you have a cell, lets say A1 with the text you want
to display in your chart/s, choose the chart and add a text box, then click
the border of the text box and type an = on the Formula Bar, then click on
cell A1 and press Enter. The text box will reflect the text in A1.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I print, displaying comments on XL Spreadsheet? 1
How DO I Increase The Excel Cell Comment Data Capacity? 1
Excel Import Comments 3
Can I link a comment to a chart ? 1
dimensions (heights) of cell comments 1
How can I set the show/hide default for comments in Excel? 1
Edit Comment Function 3
How do I print an Excel worksheet to include the comments? 1

Back
Top