Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    tables on graphs (Excel 2002 (SP3))

    I have a graph on its own worksheet. How can I place tabular data on top of it? For instance:

    1.) I would like to copy some excel rows and columns and paste them on top of the graph.

    2.) I would like to copy a word table and paste it on top of the graph.

    (I realize that a workaround would be to place the graph over a worksheet that contains the desired table.)

    Any help would be appreciated.

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

    Re: tables on graphs (Excel 2002 (SP3))

    Excel charts have a data table feature, to display the source data in the chart itself.

    You can copy an Excel table as a picture by holding down the Shift key while selecting Edit | Copy; you can then paste it on top of a chart.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: tables on graphs (Excel 2002 (SP3))

    You can add either as a "picture".

    You can take a picture of a range of cells with the The camera tool and paste this onto the chart. This "picture" is not static, but will change as the data changes. If you set it to a defined name it can also change in size as the range changes size.

    If you copy the range from the word table, you can paste it into excel as a picture and place the picture on the chart.

    I have used the technique to add a datatable onto a density or Viscosity curve to show the measured values.

    Steve

  4. #4
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: tables on graphs (Excel 2002 (SP3))

    Excellent!

    Thanks much.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: tables on graphs (Excel 2002 (SP3))

    This sounds like a good way to do it.

    I'm looking for the camera tool, but haven't yet found it...

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: tables on graphs (Excel 2002 (SP3))

    It is not on the toolbar by default. To add it to a toolbar:
    View - toolbars - customize
    Commands (tab)
    Categories: Tools
    Select the "camera icon"
    [It is about 3/4 of the way down the commands list in XL2002]
    Drag the icon to a toolbar of your choice
    <close>

    It will remain on the toolbar until you remove it.

    Steve

  7. #7
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: tables on graphs (Excel 2002 (SP3))

    I found the camera tool in Excel and it works great.

    Is it also in Word? If so, it is hiding from me.

    Thanks a bunch!

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: tables on graphs (Excel 2002 (SP3))

    I don't know, I rarely use word.

    You might have better luck asking on the Word board about it.

    Steve

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

    Re: tables on graphs (Excel 2002 (SP3))

    Word doesn't have a camera tool. You can copy part of a document, then select Edit | Paste Special... where you want to paste it. Click Paste Link and select the way you want to paste: as a Word object, as a picture, as formatted text or as plain text.

Posting Permissions

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