How do I display spreadsheet comments in a chart?

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?
 
S

Shane Devenshire

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.
 

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

Excel Import Comments 3
How DO I Increase The Excel Cell Comment Data Capacity? 1
How do I print, displaying comments on XL Spreadsheet? 1
Pulling out comments with macro 4
dimensions (heights) of cell comments 1
Show comments, but not the indicators 2
HOW DO I CREATE A DIAGRAM OR CHART FROM A TEXT SPREADSHEET 1
Showing Comments 3

Top