+ Reply to Thread
Results 1 to 2 of 2

MSChart.chartdata + Excel Names

  1. #1
    francois
    Guest

    MSChart.chartdata + Excel Names

    Hello,

    I have created a user form and trying to display a MSCHart.
    I have defined the data in a spreadhseet. This data is made three
    column Time, A1, A2. I have defined a name "Data" with these three
    column.
    THis is the cource code.

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

    When opening the user form the data from "Data" do not show up.

    Thanks for your help

    Francois

  2. #2
    Michel Pierron
    Guest

    Re: MSChart.chartdata + Excel Names

    Hi Francois,
    Try:
    Private Sub UserForm_Initialize()
    MSChart1.ChartData = Names("Data").RefersToRange.Value
    End Sub

    MP

    "francois" <francois.pierrel@invensys.com> a écrit dans le message de
    news:2b0f1e72.0502100112.1ac6e45b@posting.google.com...
    > Hello,
    >
    > I have created a user form and trying to display a MSCHart.
    > I have defined the data in a spreadhseet. This data is made three
    > column Time, A1, A2. I have defined a name "Data" with these three
    > column.
    > THis is the cource code.
    >
    > Private Sub MSChart1_OLEStartDrag(Data As MSChart20Lib.DataObject,
    > AllowedEffects As Long)
    > MSChart1.ChartData = Names("Data").RefersToRange.Value
    > MSChart1.Refresh
    > End Sub
    >
    > When opening the user form the data from "Data" do not show up.
    >
    > Thanks for your help
    >
    > Francois



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1