Graph: Setting tha heading in the datasheet

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graph not showing 3
Graphs on Forms 1
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Update Graph in Design View (VBA?) 1
Dsum and Dmax with structured references 1
Order of execution mystery 2
Graph question 5
Graphs/Charts in Access 2002 0

Top