+ Reply to Thread
Results 1 to 3 of 3

[Solved] Error Bar - custom value range won't expand

  1. #1
    Registered User
    Join Date
    08-13-2017
    Location
    Belfast, Ireland
    MS-Off Ver
    MS 2016
    Posts
    23

    [Solved] Error Bar - custom value range won't expand

    Hi

    I found a template online for creating a timelinr, and I'm using it for a study guide for work training. The aim is to trial it with my own training and then share it with colleagues to adapt for their own etc.

    I've managed to customise the various elements to my own needs for all except the error bars. I've never used these before so they're a bit of a mystery.

    I can't seem to get the custom/specified value range to expand beyond row 48 in the Duration column despite my current data ending at row 51. I will be adding more courses to this so obviously need to have the range expand.

    Can anyone tell me what I'm doing wrong or how to fix it?

    Thanks
    Attached Files Attached Files
    Last edited by liamlarmour; 06-21-2021 at 12:33 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,466

    Re: Error Bar - custom value range won't expand

    Maybe this will help: https://support.microsoft.com/en-us/...5-864049a145f0

    Almost at the bottom of the page: Change the error amount options
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    08-13-2017
    Location
    Belfast, Ireland
    MS-Off Ver
    MS 2016
    Posts
    23
    Quote Originally Posted by TMS View Post
    Maybe this will help: https://support.microsoft.com/en-us/...5-864049a145f0

    Almost at the bottom of the page: Change the error amount options
    Thanks. I ended up recreating it with a new table and graph, trial and error but got there in the end.

    Thanks though, much appreciated.

+ 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. Replies: 6
    Last Post: 11-13-2018, 04:54 AM
  2. [SOLVED] Defining Range, Custom Formula, #Value error
    By Excelnewb1567 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-12-2018, 01:50 AM
  3. [SOLVED] SUMIF formula with dynamic column range and then expand the width of SUM range
    By gravythief in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2017, 08:36 AM
  4. [SOLVED] Expand a range when you click any cell in the last line of the range
    By Dickie Dunkin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-17-2016, 03:32 PM
  5. Expand Selection for Custom Sorting
    By jhuang5132 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2014, 12:16 PM
  6. Calculating median on a filtered range. custom defined function. #NAME error in cell
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2012, 11:20 AM
  7. chart: error bars with custom error range
    By brickc1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-26-2009, 11:52 AM

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