Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2017, 03:14 AM
dutchLing dutchLing is offline Error bars in bar chart only show positive values Windows 10 Error bars in bar chart only show positive values Office 2016
Novice
Error bars in bar chart only show positive values
 
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, 13 views)
Reply With Quote
  #2  
Old 07-07-2017, 11:37 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Error bars in bar chart only show positive values Windows 7 64bit Error bars in bar chart only show positive values Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Your selected data range is A14 which only has + values
Change it to =Sheet1!$A$6:$D$12
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Error bars in bar chart only show positive values 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
Error bars in bar chart only show positive values format color of gantt chart bars based on progress? Intruder Project 7 02-02-2014 01:50 PM
Error bars in bar chart only show positive values How to show critical task bars in different color? ketanco Project 1 05-17-2012 05:17 AM
Error bars in bar chart only show positive values Error Bars Excel 2007 arthos8 Excel 1 01-30-2010 12:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft