I've exhausted my Excel guru options, and Google searches aren't pulling up much, so I figured why not try in here.
I am trying to create a visual representation of performance metrics for my team, where one chart can show us a ton of options. I also need this chart to be dynamic in that I can run the numbers once a week over a four-week period. The chart will capture the average Time to First Response (TFP), broken down by week:
Here's the part where I'm running into issues. I'd like the have each of those bars segmented so that they are each broken down by ticket type. The problem is that I can't use a default segmented chart, because that puts everything at 100%. I also can't do stacked because it throws those totals on top of the TFP bars, which doesn't help. Does anyone know how to get the existing TFP bars to become segmented without messing up the TFP totals in the chart?
If this isn't clear, I'm more than willing to elaborate.
While I agree that being insensitive is an issue, so is being oversensitive.