I had some help with this chart yesterday but have thought about it and would like to try something different. See sheet 1 on attached spreadsheet. I'd like to have Range values as a stacked column and hide the Range bottom of the stack as shown. Then have the median as a line chart, also as shown. The Sale Values Adopted can also remain as shown but the values outside the ranges will then clearly shown as in the hidden bottom of the column stack. Some problems though:
1. Want 1-4 on x axis to be labelled as As New/Full Renovated, Good, Fair and Poor.
2. The stacked columns should pull the data from each row not from the columns.
See file
Solved by K. Y. in 30 mins