Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 07-07-2017, 03:14 AM
dutchLing dutchLing is offline Windows 10 Office 2016
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, 7 views)
Reply With Quote
Old 07-07-2017, 11:37 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,228
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light

Your selected data range is A14 which only has + values
Change it to =Sheet1!$A$6:$D$12
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote

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 08:08 AM.

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