 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Show Comments in chart....
Hello all... I have a chart where I am taking a column of data and creating a chart... along that column certain cells have Comments inserted with the little red arrow in corner to designate a comment is in that cell. Is it possible to have either the entire comment or just an arrow or some sort of symbol placed on a chart? Thank you, Shhhh Hello, http://boisgontierjacques.free.fr/fichiers/graphe/GrapheCommentaire3.xls Sub commentaire() ActiveSheet.ChartObjects(1).Activate On Error Resume Next ActiveChart.SeriesCollection(1).ApplyDataLabels Type:=xlDataLabelsShowLabel On Error GoTo 0 ActiveChart.SeriesCollection(1).DataLabels.Select nb_points = ActiveChart.SeriesCollection(1).Points.Count For i = 1 To nb_points ActiveChart.SeriesCollection(1).Points(i).DataLabel.Select Selection.Interior.ColorIndex = 36 Selection.Font.Size = 7 Selection.Text = Sheets(1).Cells(i + 1, 2).Comment.Text Next i End Sub JB http://boisgontierjacques.free.fr/ > Hello all... > [quoted text clipped - 7 lines] > Thank you, > Shhhh
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.