#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
|
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 |