I'm trying to create individual range bars for each data point in a series on a line chart. For example, the first data point is 8.3, but I need the range to show 7.9 to 9. The second data point is 10.9 with a range of 10.4 to 11.1, and so on. I haven't found a way to use Excel error bars as range bars, because it only lets you format the bar for each data point so that the positive and negative values differ by the same amount (e.g. + or - .6, not + .8 and - .5). Is there a way to do this?
Bookmarks