XY Chart a reference value

Hello, I have a project where I'm querying a table and showing the data in a XY chart, so far that has gone great but I wanted to also show a median and average line for reference.

I tried adding an average and median series but the X axis is giving me issues since it won't plot the whole graph as I would like it to. Is there a trick to plot a reference value or a single item for the full length of the chart?

With an XY line chart it's fairly easy.

  • Each additional line requires two points,
    • x1 = minimum x-value in the main data series.
    • y1 = median or average value.
    • x2 = maximum x-value in the main data series.
    • y2 = y1.