Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding only vertical error bars to a single data point in a series | Charts and Charting in Excel | |||
X Y Charts - Different Label for Each Point | Charts and Charting in Excel | |||
macro to label last point for selected series only | Excel Discussion (Misc queries) | |||
Series 1 Point "0" Data Label | Charts and Charting in Excel | |||
Adding comments to series and fixing it to a point | Charts and Charting in Excel |