+ Reply to Thread
Results 1 to 2 of 2

Charts stop plotting data error bars after a certain number of data point selected

  1. #1
    Registered User
    Join Date
    06-06-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Unhappy Charts stop plotting data error bars after a certain number of data point selected

    In the attached document is a timeline made from a scatter chart. Error bars using custom values are used to show the length of each task, however I can't get the chart to include error bars for the last 2 data points (tasks).

    Anybody have any ideas? In my experience excel charts can act funky if they are complex and/or have many data points.

    Thanks for the help!
    Jason
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,835

    Re: Charts stop plotting data error bars after a certain number of data point selected

    Opening the "format error bars" dialog and looking at what is specified for the x error bars positive value, it is pulling data from E37:E51 for the x error bars. The data table extends to row 53, so the last two rows are not included in the error bar definition. I think you just need to go into the dialogs that define these error bars and make sure all of the desired rows are included. If you need help finding the dialog, see "changing error amount option" in this help file: http://office.microsoft.com/en-us/ex...010342159.aspx
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Error Bars by Data Point instead of Series
    By riwiseuse in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-06-2010, 05:40 PM
  2. How do I add error bars unique to each data point?
    By Glenn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-08-2005, 07:05 PM
  3. How do I set different error bars per data point in a series
    By Trebor1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-03-2005, 09:05 AM
  4. Error bars for a single data point not whole series
    By Helen in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-13-2005, 02:06 PM
  5. Replies: 1
    Last Post: 01-21-2005, 01:06 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