+ Reply to Thread
Results 1 to 2 of 2

Excel Graph, Error Bars

  1. #1
    Registered User
    Join Date
    02-15-2017
    Location
    Bristol
    MS-Off Ver
    2016
    Posts
    2

    Excel Graph, Error Bars

    I have error bars on my graphs and they are forcing the rest of my graph into a minus, I want just the error bars to go into a minus and not my bar charts. I would like my bar graphs and lines to rest on 0 and not go below 0 How can I do this? Thank you.

    Untitled.png

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

    Re: Excel Graph, Error Bars

    I'm not sure I understand exactly what you want. As a first guess is that you somehow want the 0's for the primary and secondary Y axes to match up, is that correct, or are you trying to do something else?

    If that is the desired goal, I would do this (manually for now, this can be automated later once you have determined that this is what you want).
    1) Open format axis dialog for the primary Y axis.
    2) Make the primary axis proportional to the secondary axis. For mathematical simplicity, I decided to divide the secondary axis values by 20
    2a) Set primary axis max to 35 (700/20)
    2b) Set primary axis min to -5 (-100/20)
    3) Make sure that the "horizontal category axis crosses at" property stays at automatic or 0.

    See if that is what you are trying to do here.
    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 not showing up on Graph
    By raven3321 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-15-2016, 02:54 AM
  2. markers for error bars in clustered column graph
    By Andreea C. in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 11-20-2013, 10:18 AM
  3. Replies: 2
    Last Post: 03-28-2012, 02:29 PM
  4. Multiple Error Bars on Graph
    By stefc884 in forum Excel General
    Replies: 7
    Last Post: 05-02-2010, 09:01 AM
  5. Individual Error bars in bar graph
    By Naz_1 in forum Excel General
    Replies: 0
    Last Post: 03-10-2008, 02:46 PM
  6. Label Error Bars in Graph...Help!!!
    By Mcadams6834 in forum Excel General
    Replies: 0
    Last Post: 08-24-2006, 11:39 AM
  7. How do I plot mean and error bars in Excel?
    By rik827 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-16-2006, 07:10 PM
  8. 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