Results 1 to 3 of 3

insert table into chart sheet

This is a discussion on insert table into chart sheet within the Excel Questions forums, part of the Question Forums category; Hi, I was wondering if anyone new how to insert a table into a chart sheet. I already have a ...

  1. #1
    New Member
    Join Date
    Oct 2006
    Posts
    16

    Default insert table into chart sheet

    Hi, I was wondering if anyone new how to insert a table into a chart sheet.

    I already have a chart on its own sheet and I want to insert a table from another workbook onto that chart sheet.

    Thanks!

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    3,690

    Default

    Some charts support a Data Table, which is a rather inflexible table of the data in the chart. For this go to the Chart menu, choose Chart Options, then check the box on the Data Table tab.

    If that doesn't help, you can try the Camera tool. First you need to add it to the toolbars. Go to Tools menu > Customize... > Commands tab. Click Tools in the left list, then scroll 2/3 down the right until you find the Camera item, and drag it to a convenient place on the toolbars. Select the range you want to copy, click the Camera tool, then move to the chart sheet and click near where you want it.

    Another way is to copy the range as a picture: hold Shift, then select the Edit menu, and click on Copy Picture. Choose the On Screen and Picture options. Go to the Chart and paste. Then select this picture, click in the formula bar, then scroll and select the range, so the formula bar shows the link, something like =Sheet1!$A$1:$D$6. I've just decided that I like this technique a bit better than the Camera tool.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try the Peltier Tech Chart Utility

  3. #3
    New Member
    Join Date
    Oct 2006
    Posts
    16

    Default

    Thanks! I'm going to try this. Great to hear the different options as well. They will come in handy some day.

    Rebecca

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com