Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

Quick Excel questions about charts

  • 28-04-2015 11:55AM
    #1
    parc
    Registered Users, Registered Users 2 Posts: 797 ✭✭✭


    Hi,

    I want to move a table and its chart into a new excel sheet. How do I do this so that it keeps the original format/function

    ie in the pasted table/chart, if I change a number in the table, it will change in the chart (like the original)

    I've tried paste special > MS worksheet object and this works fine until I double click on a cell and it links to the old table


Comments

  • #2
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 95,751 Mod ✭✭✭✭Capt'n Midnight


    parc wrote: »
    Hi,

    I want to move a table and its chart into a new excel sheet. How do I do this so that it keeps the original format/function

    ie in the pasted table/chart, if I change a number in the table, it will change in the chart (like the original)

    I've tried paste special > MS worksheet object and this works fine until I double click on a cell and it links to the old table
    yes formula's and stuff may link back to the original sheet,

    You could copy the entire sheet - right click on the tab at bottom and move/copy , create a copy - again problems if you link to stuff on another sheet , which will now be in the original file


  • #3
    Dr_Bill
    Registered Users, Registered Users 2 Posts: 295 ✭✭Dr_Bill


    Might be easier to just make a copy of the excel file itself and then make your changes?


Advertisement