2 Replies Latest reply on Jun 11, 2018 7:52 AM by Denis Kelly

    Pricing range question - high, low, average all on same axis (stock chart)

    Denis Kelly

      I would like the 3 elements included in the data (low price, high price, average price) displayed on the same bar chart but since the scale of each value is disproportionate I am looking for a way to normalize the data.  This should be able to be done by having a % total measure display for each line ((Current price-Max price)/(Max price - Min price)).  This proportion would then show the "% of total" which would enable a graph to show $300 price data vs. $50 price data.  Raw example shown below.  How can a graph be created to complete this?

       

      Price 06 08 18.PNG

       

      Also attaching tableau file here:

       

       

       

      Thanks!