Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    a movable table (excel)

    I am tring to make a table which is like a chart in that it can be sized and moved by using the mouse.
    is this possible in excel? attached is my table which is basic but not what I am needing

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

    Re: a movable table (excel)

    You can use the camera tool to "take a picture" of your table and place it as a movable, resizable object on a sheet.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2004
    Location
    Stoney Creek, Ontario
    Posts
    196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: a movable table (excel)

    Is this what you are looking for?

    Highlight all the cells in the table. Hold down the shift key, choose Edit - Copy Picture. Paste the picture (your table) where you want it.

  4. #4
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: a movable table (excel)

    ahh never knew about that niffty tool,
    but it still pastes it as cells and can only be sized by making the cells bigger

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

    Re: a movable table (excel)

    What do you mean by "resizable" then?

  6. #6
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: a movable table (excel)

    Thanks Deb,


    Do you know any ways of making the table look more appealing... cell shading and shadowing
    ect...?

  7. #7
    2 Star Lounger
    Join Date
    May 2005
    Location
    Wilcox, Saskatchewan
    Posts
    171
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: a movable table (excel)

    when clicking on the object and being able to resize it by draging a corner

  8. #8
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: a movable table (excel)

    Seaner

    Even if the Camera tool is not on a toolbar, you can get exactly the same effect by following these steps:

    1) Select the range
    2) Choose Edit - Copy
    3) Press the Shift key and choose Edit - Paste Picture Link (this command is available only when the Shift key is pressed).


    The result is a linked picture of the original range. You can move this picture anywhere you like and you can resize it
    Jerry

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

    Re: a movable table (excel)

    Any of the methods described in this thread will allow you to resize the picture by dragging a corner.

  10. #10
    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: a movable table (excel)

    If you use the camera tool, formatting the original source will change the formatting of the picture.

    Steve

  11. #11
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Toowoomba, Queensland, Australia
    Posts
    112
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: a movable table (excel)

    Can I jump in here with an extension to this question - not a hijack (at least I hope not)

    I saw an Excel worksheet that had a graph and alongside it there were radio buttons marked Qtr1, Qtr2 etc., When the user clicked on a button, the graph changed to show the data for the selected quarter. This was done without macros and I've tried to recreate it with no real success. I'm almost positive it used the camera tool and that the graphs for all 4 quarters existed elsewhere on the sheet.

    Hope this makes sense.

  12. #12
    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: a movable table (excel)

    Is this what you are after?

    It does not require the camera, just formulas set up correctly. The radio buttons tell what to lookup so the chart changes based on the lookup and the calcs.

    Steve

  13. #13
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: a movable table (excel)

    Joe,
    Attached is a workbook with a simple chart controlled by a combo box.
    There are no macros. Note that the source range for the chart never changes,
    but the data in the source range does.

    Jim Cone
    San Francisco, USA

  14. #14
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Toowoomba, Queensland, Australia
    Posts
    112
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: a movable table (excel)

    Thanks for that example. It does the job, but I'm nearly certain that the one I saw earlier used the camera or some sort of picture object that was linked to the radio buttons iykwim.

  15. #15
    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: a movable table (excel)

    Here is a way using the camera tool. This has advantages if your charts are not formatted the same or of different types.

    The earlier is if you only need 1 chart and you just want to change the data that is charted. I prefer the first method (without the camera) since it eliminates the need to create every chart, you literally only have 1 chart that just plots many different ways. This way forces you to create all the charts and then name the areas behind them.

    Steve

Page 1 of 2 12 LastLast

Posting Permissions

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