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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Quick Excel questions about charts

  • 28-04-2015 10:55am
    #1
    parc
    Registered Users, Registered Users 2 Posts: 792 ✭✭✭


    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: 93,581 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