Graphing a column range with 1 overlapping scatterpoint

[INDENT]im trying to graph a range using floating columns (from low point to high point) then one scatter point which will move daily. i tried eliminating the border line/fill in a stacked column graph for the lower segment but i cant even begin to figure out how to plot an individual scatter point for each series.... i attached my spreadsheet which is a better visual of what im describing. im basically trying to create a range low-high in a floating column then add a moving daily data point which will plot inside the range. thanks[/INDENT]