Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Adding a custom label to a series point

Hello,

is there away to add text to a series point? I have a graph and I would
like to add a text description of one of the points, i.e. "year one
results".

If possible I would like to be able to do this in Excel VBA, which
would enable some data analysis before labelling a point.

Any suggestions would be appreciated

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Adding a custom label to a series point

With ChartObjects(1).Chart.SeriesCollection(1).Points(2 )
.HasDataLabel = True
.DataLabel.Text = "year one results"
End With
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"den1s"

wrote in message
Hello,
is there away to add text to a series point? I have a graph and I would
like to add a text description of one of the points, i.e. "year one
results".
If possible I would like to be able to do this in Excel VBA, which
would enable some data analysis before labelling a point.
Any suggestions would be appreciated

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
Adding only vertical error bars to a single data point in a series Chris Wagner, Northern Michigan Univ. Charts and Charting in Excel 6 May 13th 23 11:44 AM
X Y Charts - Different Label for Each Point D. Wilkerson Charts and Charting in Excel 3 December 11th 09 03:29 AM
macro to label last point for selected series only EricBB Excel Discussion (Misc queries) 1 January 22nd 09 10:56 AM
Series 1 Point "0" Data Label Keyrookie Charts and Charting in Excel 2 November 15th 07 01:06 PM
Adding comments to series and fixing it to a point Nacho Charts and Charting in Excel 1 May 3rd 05 01:31 AM


All times are GMT +1. The time now is 04:33 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"