Results 1 to 6 of 6
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Problems with links to charts (2003)

    The chart with the square black dots is inline with text.
    The chart with the round open dots is floating.
    You can change this as follows:

    - Select the chart.
    - Select Format | Object...
    - Activate the Layout tab.
    - Set the Wrapping Style to "In line with text" (the preferable option in my opinion).
    - Click OK.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problems with links to charts (2003)

    Edited by HansV to reduce picture in size - please don't post pictures larger than 640 x 480 pixels.

    I think this is a Word issue, although it could be Excel.
    I am writing an audit report in which data tables and associated charts, instead of being typed in the document, are built in Excel and links to these inserted into the document.
    In order to make document layout more consistent, I decided to use a one row, two cell table to hold the linked data table and its chart, one in each cell. I created the table, set the table properties I wanted, copied it and pasted it into every location in the word document where links were required.
    I assumed that this would ensure that the linking mechanism would be consistent throughout the document.

    On the Excel side, each chart was created using the same method I set the style of chart I wanted as default in Custom Types | User Defined within the Chart Wizard.

    Finally, I created a macro in Word to create a link using Paste Special with appropriate options to put the contents of the clipboard into a cell.

    So I would copy a chart, switch to Word, make sure the cursor was in the correct cell and run the macro to create the link. All seemed OK as the charts appeared and double clicking on them opened the Excel file; right clicking on the chart showed that it was, indeed, a link.

    However, in the accompanying picture, it can be seen that some of the chart links differ from others. The selection in the top half of the picture (black square dots) behaves like a chart link; the selection in the lower half of the picture is (clear, round dots) is a picture which behaves a bit like a chart link but not quite the same.

    For example, I cannot show the field/link code for the picture object. If I select the whole document and use Shift+F9 to toggle the codes, it does nothing with these objects; the picture remains. All objects like the one shown in the top half toggle the field codes. However, the picture objects are definitely links; double clicking on them opens the Excel file.

    Why has this happened and how can I force all the chart links to be like the one shown in the top half (black square dots), please?
    Thanks
    Silverback
    Attached Images Attached Images
    • File Type: jpg z.jpg (36.5 KB, 0 views)
    Silverback

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problems with links to charts (2003)

    Hello, Hans
    Well, again you have solved the problem, but this is very bizarre.
    I followed your instructions to Format Object and change to In line with text. The sequence of events was that an hour glass appeared showing that the link was being updated. Then the updated chart was displayed (proved that because I changed the Excel chart data before I did the format object), then Word displayed Error : Invalid Link!
    I've forced a solution but I don't know why it works. These cells were completely empty when the link was created. I restored the chart 'Invalid link' by undoing the action, then cut the chart from the cell. I then added some blank lines by pressing enter a few times then pasted the chart back into the cell. However, at first try the Format Object still failed. So then I unset the 'Move object with text' tick box in the Advanced Layout options. The 'In line with text' now worked and it changed the chart in situ; no error. I then deleted the redundant blank lines/paragraph markers.
    So the document is now consistent throughout -for which, thank you very much. <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>
    But it begs the question as to why out of 138 chart links, only six of them were created with 'floating' attributes and the rest came in with 'In line' attribute.
    Any ideas?
    Thanks
    Silverback
    Silverback

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

    Re: Problems with links to charts (2003)

    Sorry, I have no idea why that happened. When pasting a chart, it should use the setting of the "Insert/paste pictures as:" dropdown in the Edit tab of Tools | Options..., so either they are all inserted in line with text, or all inserted floating, unless the setting has been changed in between.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problems with links to charts (2003)

    OK - that option was set to Tight(!) so now the puzzle is how the majority got set as In Line.
    Anyhow, all is fixed now, so I'm going to put this down to "that's what happens when you use computers". <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Thanks again
    Silverback
    Silverback

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problems with links to charts (2003)

    PS : Sorry about the picture size. I'll remember if I have to post a picture again.
    Silverback.
    Silverback

Posting Permissions

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