| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
writing data to a textbox in a chart
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data showing incorrectly on line chart | Charts and Charting in Excel | |||
| How do I number format the Data Table in an Excel Chart? | Charts and Charting in Excel | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
