turning chart values on

[User4Fun]

Sheets("ACUITY Vs ISTEP GRAPH").Charts("acutep").ApplyDataLabels = True


How can I make the values at the points ofthe graph show???

 

[electricpete]

Asssuming your chart "acutep" is embedded in a sheet "ACUITY Vs ISTEP GRAPH". try something like this:


Worksheets("ACUITY Vs ISTEP GRAPH").ChartObjects _
("acutep").Chart.SeriesCollection(1).ApplyDataLabels _
Type:=xlDataLabelsShowValue, AutoText:=True, _
LegendKey:=False

 

[electricpete]

Correction, I'm not sure if you can use the chart name as an argument to chartojects.

But if it is the only chart in the sheet than you can pull it out of the sheet chartobjects collection using index 1, like this:

Worksheets("ACUITY Vs ISTEP GRAPH").ChartObjects _
(1).Chart.SeriesCollection(1).ApplyDataLabels _
Type:=xlDataLabelsShowValue, AutoText:=True, _
LegendKey:=False

 

[User4Fun]

it works great, thanky ou very much. What would you do to turn the values off?

 

[electricpete]

Start your macro recorder
Select series on the chart
Right-click and select "format data series"
On the tab labeled data labels, click "none"
turn macro recorder off an inspect the code
)