Line Chart with X-Axis Values [CHART FORMATTING HELP]

  • Hello -


    I am trying to format a line or scatter plot chart like the screenshot attached within the workbook, but am not familiar enough with chart formatting to achieve the desired result. Anyone have any ideas?


    X-Axis
    Min of listed values
    Max of listed values


    Y-Axis
    Bars that represent the range for each category; using a 'helper cell' next to each category to space them out vertically.


    Any help would be awesome!
    Thanks!
    -Kyle

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!