Please see the attached representation of the desired plot. For 2011 - 2014, there is only one y value for each x value. However, for 2015 and beyond, each x value is associated with a range of y values--in those cases, I would like to plot the range minimum, the range maximum, and possibly a vertical line to connect the min and max. Can this be done in Excel 2010? I'm not certain how to set up the data in order to produce such a plot.
Thank you!
Bookmarks