How do I create an Excel =Series chart

[andrewcarrara]

I am trying to recreate a spreadsheet provided. The below chart used the =Series function and passes three values to the chart for the best worst and average values.

Is it possible to create this chart in Power BI?

This is a screenshot of what excel produces as the chart.

[andrewcarrara · Accepted solution]

I ended up stacking 3 charts on top of each other to accomplish this chart.  

[Anonymous]

Hi @andrewcarrara ,
Thanks for  lbendlin reply. Box and Whiskers chart is similar to the chart you post.

You can also use line and stucked column cahrt to create in power bi

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

Looks like you want a Box and Whiskers chart?