Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    link data sheet to data sheet (Office 2000/2003)

    Is it possible to link the data from one chart to another (i.e. the data sheet within a chart). I know one can link an actual table to the datasheet of a chart, but I haven't found a way to do it data sheet to data sheet. Here is the scenario. I am using a third party software to export the chart to Excel, however this chart is pretty ugly and needs a lot of formatting. Thus I created a 'master file' which will be used, and I would like to use the exported file as a source file with link to the master file. The source file will be exported every month with the same name (I also have tables, which I have already linked to the masterfile, now I'm only stuck at the charts). Any ideas anyone?

    Thanks,
    K.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: link data sheet to data sheet (Office 2000/2003)

    What kind of chart do you get as a result of the export? A Microsoft Graph object, or an Excel chart object, or...?

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: link data sheet to data sheet (Office 2000/200

    I think it is an msgraph type, when I click on the chart I have in the formula bar: =EMBED("MSGraph.Chart","")

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: link data sheet to data sheet (Office 2000/200

    I don't think you can link to the datasheet in an MS Graph chart. You can open the datasheet manually, and copy the data to the clipboard in order to paste it elsewhere, or you can write VBA code to read the data from the datasheet and use it elsewhere.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: link data sheet to data sheet (Office 2000/200

    Ok, thanks a lot for confirming.

    Cheers,

    K.

Posting Permissions

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