Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How do I create an Excel =Series chart

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.

Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

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

     

     

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,
    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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