writing data to a textbox in a chart

C

CLamar

Hello I am trying to write some information about the graph in a text box, on
a chart. The data comes from an array. The array values should be placed in
the text box one line after the other. I can not get it to do this. Below
is what I have Area(j) is the array with the values in it

j = 1

Charts("" & FDirect & "" & Har &
"").Shapes.AddTextbox(msoTextOrientationHorizontal, 461.09, 48.18, _
175, 103.25).Select

For j = 1 To i
Selection.Characters.Text = "" & Area(j) & "" & vbCrLf
Selection.AutoScaleFont = False
Next j
 

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

Pie Chart Data labels 0
Data Source for excel graph 1
Bizarre chart behaviour when changing axis cross at points 2
Getting debug error as "code execution has been interrupted" 0
Writing multicolumn array data to a worksheet range 6
New topic from discussion "Align cells with same value - vba almostworking" in this group 0
Writing Data to cells 2
Reverse a function to return the array? 4

Top