Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I display spreadsheet comments in a chart?

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 857
Default How do I display spreadsheet comments in a chart?

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"GTYT" wrote:

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I display the comments when I print in Excel? Excel comments Excel Discussion (Misc queries) 6 November 30th 07 09:16 AM
display comments Louis Charland Excel Discussion (Misc queries) 4 May 23rd 06 02:20 AM
Display Comments on Each Page Stanley Excel Discussion (Misc queries) 0 February 23rd 06 06:05 PM
Can I display comments in a validation list Stoke Excel Worksheet Functions 1 February 3rd 06 06:14 PM
display comments jlschott2 Excel Discussion (Misc queries) 1 October 18th 05 03:54 PM


All times are GMT +1. The time now is 09:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"