Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exporting Column Chart (2003)

    In the Excel template, there is sheet 1 containing data and a sheet 2 that has a column chart with a data source from sheet 1. I would like to copy and reference this chart to my Word document. In addition, i would like the column chart to be updated when the data in sheet 1 from Excel changes. Would it be better if I consolidated sheet 1 & 2 together? Please let me what steps I need to take to attain my goal.

    TIA,
    WordNewby

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

    Re: Exporting Column Chart (2003)

    In my experience, this works better with a chart embedded in a worksheet than with a separate chart sheet, but you can obtain your goal with either.

    Open your Excel workbook.
    Activate the second sheet.
    If this is a worksheet that contains the chart as an embedded object, click once on the chart to select it.
    If it is a chart sheet, click somewhere outside the actual chart.
    Select Edit | Copy or press Ctrl+C.

    Open your Word document.
    Place the insertion point where you want the chart.
    Select Edit | Paste Special...
    Click the "Paste Link" radio button.
    Select "Microsoft Excel Chart Object" in the list.
    Click OK.

    You now have a linked chart in your Word document. If you change the source data in Excel, the chart will be updated automatically.
    If the linked chart is too large to fit on the page (so that parts appear to be missing):
    - Click once on the chart to select it.
    - Resize it, either by dragging one of the black "handles" in the corners of the chart, or by using the Size tab of Format | Object...

  3. #3
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Column Chart (2003)

    Yoohoo...this works great...Thank you....AGAIN...I now owe you my life.. <img src=/S/hailpraise.gif border=0 alt=hailpraise width=27 height=22>

Posting Permissions

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