D
DianePDavies
How do I set the label on a column from VBA?
From the graph-help I have:
myChart.Application.DataSheet.Range("A0").Value = "Annual Sales"
But my problem is to make the reference to myChart.
My chart is namet "plot1" in my form "graph", so I adress it like
forms!graph!plot1.application.DataSheet.Range("A0").Value = "Annual Sales"
but it doesn't work!
Any suggestions?
From the graph-help I have:
myChart.Application.DataSheet.Range("A0").Value = "Annual Sales"
But my problem is to make the reference to myChart.
My chart is namet "plot1" in my form "graph", so I adress it like
forms!graph!plot1.application.DataSheet.Range("A0").Value = "Annual Sales"
but it doesn't work!
Any suggestions?