5 Replies Latest reply on Jun 20, 2018 12:00 AM by Mavis Liu

    Different colours for Bar chart ,same dimension based on order

    keerthana kumar

      Hi All,

       

      I have data in the below format.  For eg as below, in 201804 i take what value was forecasted for 201804 from 201801 - 201801 (n-3 -n),then the actuals,bp and ly to plot a graph as below

      sample data.JPG

                                                                       my dashboard

      my result.JPG

      I want forecast bars (orange) to be in different colors  i.e, prediction,2,3 different colors  according to the order - lighter shade of orange,dark orange,darkest orange

      and is there a way to change it to clustered graph format.

       

      Please find the attached sample workbook. 10.1. Let me know if there is any option.