Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Min/Max Avaerage column chart

Hello All, 

 

I am trying to create a min, max, and average column chart; I have seen an existing solution using stock charts for the min/max but that requires the use of dates.  I am trying to create a visual shown below; that uses categories along the x-axis.

  

I have tried a box-whisker plot also, but it is not entirely relevant based on my data-set. 

 

Thanks.

 

 

 

Need Help

8 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    You'd better post your sample data and desired result, so that we can share detailed solution which is close to your requirement. It's really hard to reproduce your scenario without sample data.

    Thanks,
    Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi  v-huizhn-msft

       

      Apologies, I have attached the sample data.  The idea is the minimum value will stem from the relevant minimum value within the category, rather than the minimum of the entire data set. 

       

      OneDrive Link

       

      Thanks.

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        8 years ago

        Hi Anonymous

         

        Try "Line and stacked column chart"

         

        Put the Min and Max in Column values

        Put the average in Line Values

        Uncolor the Min Column