1 Reply Latest reply on May 24, 2013 5:28 AM by Jonathan Drummey

    Cumulative bar chart with area filled with color

    Krishna Prasad

      Hi all,

       

      I dont know how to name this type of chart but my requirement is to get a chart filled with color to show the magnitude of cumulative sales. Here I am attaching the packaged workbook which made it in a very crude way to fill that area by annotation manually. But I want this to have dynamic everytime my data is refreshed/filters applied.

       

      Data is sales and profit. I want profits to be cumulative on descending of sales and show different colors at each category.

       

      Snap show of my requirement looks like this:

      Chart1.jpg

       

      Thanks a lot for taking time to check my packaged work book.