Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-07-2017, 03:14 AM
dutchLing dutchLing is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2017
Posts: 1
dutchLing is on a distinguished road
Default Error bars in bar chart only show positive values

Dear list,

I'm currently trying to create a chart with custom defined error bars (see attachment). However, when I try to define both directions for the error bars, only the positive direction is displayed. Could you please tell me how to fix this issue? Thanks in advance!



Kind regards,

dr. Marco van de Ven
Attached Files
File Type: xlsx graph.xlsx (15.4 KB, 6 views)
Reply With Quote
  #2  
Old 07-07-2017, 11:37 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,914
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Your selected data range is A14 which only has + values
Change it to =Sheet1!$A$6:$D$12
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
I Can't Get Change Bars to Show up Nathan8752 Word 3 10-08-2015 04:15 PM
Names and resources of Gantt chart bars michaeljm Project 5 06-09-2015 09:40 AM
format color of gantt chart bars based on progress? Intruder Project 7 02-02-2014 01:50 PM
How to show critical task bars in different color? ketanco Project 1 05-17-2012 05:17 AM
Error Bars Excel 2007 arthos8 Excel 1 01-30-2010 12:27 PM


All times are GMT -7. The time now is 06:32 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft