+ Reply to Thread
Results 1 to 5 of 5

Error Bars not showing up on Graph

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    4

    Error Bars not showing up on Graph

    Hi all,

    Please refer to the attached excel spreadsheet. For Figure 2, the error bars will show for the 4-5 & 6-7 age groups, but they won't appear for the 8-9 age group. It has a custom value equation that appears in the first two groups but not in the third and I can't figure it out. Any help would be appreciated. Thanks.

    Raven
    Attached Files Attached Files

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

    Re: Error Bars not showing up on Graph

    You need the same number of error bar values as you have data points. Currently you do not have enough error bar data points. Insert spacing between age bands as you have for the main chart.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-19-2013
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2011
    Posts
    4

    Re: Error Bars not showing up on Graph

    Thank you Andy. I appreciate it.

    Raven

  4. #4
    Registered User
    Join Date
    08-15-2016
    Location
    Philippines
    MS-Off Ver
    2010
    Posts
    1

    Re: Error Bars not showing up on Graph

    Thanks for both of you!

  5. #5
    Registered User
    Join Date
    12-28-2023
    Location
    Tbilisi,Georgia
    MS-Off Ver
    2016
    Posts
    1

    Re: Error Bars not showing up on Graph

    Thanks alot!

+ 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. Custom error bars not showing
    By JMU_TOM in forum Excel General
    Replies: 1
    Last Post: 08-04-2011, 10:01 AM
  2. Multiple Error Bars on Graph
    By stefc884 in forum Excel General
    Replies: 7
    Last Post: 05-02-2010, 09:01 AM
  3. Individual Error bars in bar graph
    By Naz_1 in forum Excel General
    Replies: 0
    Last Post: 03-10-2008, 02:46 PM
  4. Label Error Bars in Graph...Help!!!
    By Mcadams6834 in forum Excel General
    Replies: 0
    Last Post: 08-24-2006, 11:39 AM
  5. [SOLVED] How can I change a graph with 2 bars,2 lines to 3 bars, 1 line?
    By IOWAJulie in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-19-2005, 07: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