2 Replies Latest reply on Aug 15, 2016 7:49 AM by Luciano Vasconcelos

    Stacked Bar Total on Unstacked Bar Chart

    Seanna Miller

      I'm trying to create a chart that shows duration between various statuses as a bar chart - let's say the difference between the Order Date and the Ship Date if I were looking at the Superstore sample data, expressed as an average, by region:

       

      That's easy enough to do... But what I want to do now is to add a "grand total stacked bar" that acts as a stacked bar, that shows the breakdown of the average times by region as an additional line in the chart. Here's what the bar looks like:

       

       

      So the end state graph would show the two separate graphs above on the same chart. It's easy enough to get a solid Grand Total bar by using the options in the Analysis menu, but it doesn't give me the breakdown by Region in this case.

       

      Does anyone know if this is possible?