Help! I've spent (more than) a few hours playing with Inserting a Chart needed badly...
Data is several series with a High and Low value on an X-axis (not sequential).
I'd like to create a bar chart with one series bar starting at the 'low-Y' and with top at the 'high'-Y. I can do this by clustering the two data points with 100% overlap, the 'low-Y' being no fill/ no outline in front of the 'high-Y'.
What I can't figure out is how to have several series of these "overlapped low/high" bars clustered at a given X-value.
! I hope this is somewhat clear ! I pray there's someone out there that can help !
Bookmarks