+ Reply to Thread
Results 1 to 2 of 2

moving graph data problem

  1. #1
    Registered User
    Join Date
    03-07-2019
    Location
    Woecester, England
    MS-Off Ver
    2010
    Posts
    4

    moving graph data problem

    Hi All

    I have a sheet with lots of graphs in with the data for each graph above each one.

    I have to move the order of the data and graphs and i'm trying to find the easiest way to do it.

    My question is can I move the data for each graph without having to edit the data range for each graph? ie is there a way to 'lock on' the data so wherever it is or moved to the graph will
    always pick it up?

    Thanks

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    15,040

    Re: moving graph data problem

    My suggestion is to make a copy of the file, that is "Save as" the file with a different name i.e. if the file is named file 1 "Save as" file 1_2 so that you have a copy with which to experiment.
    See if moving the data and the graphs on your copy (file 1_2) causes problems.
    If so then utilize the instructions in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page, so that we have a better idea of what is being attempted.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Moving all data points closer to the trend line on a graph
    By curiousasd in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 09-25-2019, 09:18 AM
  2. [SOLVED] Problem Moving Data from one Sheet to Another
    By vbaNewbieMan in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-11-2014, 11:10 AM
  3. Moving an Excel chart's data points (Variable Problem)
    By AliJay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2010, 03:51 AM
  4. Problem moving data between worksheets
    By Timeferret in forum Excel General
    Replies: 3
    Last Post: 02-10-2009, 05:29 AM
  5. Problem moving data to new workbooks
    By madbloke in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2007, 11:17 AM
  6. [SOLVED] Problem moving data
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2006, 06:15 PM
  7. Problem moving data from Access to Excel
    By Jesse Aviles in forum Excel General
    Replies: 5
    Last Post: 08-06-2005, 09:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1