+ Reply to Thread
Results 1 to 5 of 5

Offset Chart Data Question

  1. #1
    Registered User
    Join Date
    03-07-2021
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    6

    Offset Chart Data Question

    Hello,

    If I have entered my chart data/labels arguments, and later find that there's an error, is there a way to go back and edit the arguments?
    When I try to correct the argument data now, it won't allow me to enter it under the same "name" because it's already been entered under the (same) name.

    Of course, I can create a new entry under a different name, but it would be time saving if I knew of a way to edit my original entry...

    Hope this makes sense!

    Thanks in advance!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Offset Chart Data Question

    You should be able to use the Select Data dialog to adjust range references of series in a chart.

    Also selecting a series in a chart, if contiguous, should apply coloured border around range that you can move and resize.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-07-2021
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    6

    Re: Offset Chart Data Question

    Thanks to Andy Pope!
    Much appreciated.

  4. #4
    Registered User
    Join Date
    02-01-2021
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2016
    Posts
    1

    Re: Offset Chart Data Question

    Quote Originally Posted by WCBC View Post
    Hello,

    If I have entered my chart data/labels arguments, and later find that there's an error, is there a way to go back and edit the arguments?
    When I try to correct the argument data now, it won't allow me to enter it under the same "name" because it's already been entered under the (same) name.

    Of course, I can create a new entry under a different name, but it would be time saving if I knew of a way to edit my original entry...

    Hope this makes sense!

    Thanks in advance!
    You can use "Select data dialogue" in this regard.

  5. #5
    Registered User
    Join Date
    03-07-2021
    Location
    Vancouver, Canada
    MS-Off Ver
    2010
    Posts
    6
    Quote Originally Posted by niamul21 View Post
    You can use "Select data dialogue" in this regard.
    Thank you!

+ 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. Offset data in a line chart
    By mrtiffy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-21-2020, 08:05 AM
  2. Dynamic named range using OFFSET for chart series data isn't quite right....
    By mnschwarz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2019, 03:59 AM
  3. Offset Table Data for Dynamic Chart
    By Alex1991 in forum Excel General
    Replies: 2
    Last Post: 10-03-2018, 07:50 AM
  4. Data Validation question regarding OFFSET
    By Bonzopookie in forum Excel General
    Replies: 4
    Last Post: 07-14-2016, 02:28 PM
  5. [SOLVED] Interval-Y in duplicate chart go offset when data update
    By DavidRoger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2014, 09:52 AM
  6. Selecting Offset Chart Data
    By gtiguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2012, 02:40 AM
  7. Offset / Data Validation Question
    By Jgodean2 in forum Excel General
    Replies: 1
    Last Post: 01-03-2011, 04:33 PM

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