MSChart.chartdata + Excel Names

F

francois

Hello !

I have defined a name whithin excel which I have called data. This
names is a three column data (say; Time, A1, A2)
I have created a form in VBA and created a chart with the MSchart
active X. The ode goes like that:

I have used the XY scatter chart type

Private Sub MSChart1_OLEStartDrag(Data As MSChart20Lib.DataObject,
AllowedEffects As Long)
MSChart1.ChartData = Names("Data").RefersToRange.Value
MSChart1.Refresh
End Sub

When I open the form the data from the defined "Data" do not show.

I have found lots of stuff on MsCHart for VB but not so much for VBA.

Thanks all.

Francois
 

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

MSChart.chartdata + Excel Names 1
Add additional information to excel form after original data entry 0
Grouping Names in Mail Merge 0
Possible to Combine reports to's to a single box? 0
Integrating information from Word to Excel (not mail merge) 1
Displaying Data Forms in Excel 2016 for Mac 0
Need Help with a VBA subroutine 0
OWC (office web component ) chart , stacked XY scatter 0

Top