Are you available for another excel project?
This time I need data displayed to spec. I think this is easy, but it beyond my skills. I'm estimating it is just a one hour, maybe two hour job. Not much, but it's all I have.
I'm uploading a scan with notes.
change data points to be a bar reflecting both low and high from columns C and D.
Color code the data by values in column B (A B C are the major values, but several fit between, so use 5 values instead of 3 to cover them all)
Add a data range for columns E and F, same style. You'll need to muck with the axis to get these much smaller numbers to array similarly.
Once you have it set, adjust the axis to eliminate dead space and give the data some room to display.
Final deliverable: leave the chart on the same page/sheet as the data. I'll want to zoom in on the chart, but have the data on the same page for ready reference. My users will get confused if they have to flip between sheets. We don't have room for the names to appear, so they'll want the data handy.
Please let me know if you are interested!