kfairhurst
New Member
- Joined
- Oct 2, 2018
- Messages
- 1
Hi - I am trying to create a stacked bar chart to show the life cycle of the status of a job. Say the job changes between 3 different status' multiple times.
eg: 1 day 'with customer', 1 day 'with support', 2 days 'awaiting information', 2 days 'with support', 1 day 'with customer'
When using a pivot chart it is showing the sum of of the number of days for each status rather than the lifecycle.
I have managed to create the stacked bar chart to show the changing status throughout the lifecycle of the job using my own table but I had to leave separate legend entries for each stage, excel has allocated a different colour for each section of the stacked bar chart even if the label is the same, I can edit the colours so it displays correctly but cannot get the legend bar at the side to assign just one line to each status without it removing it from the stacked bar.
I hope that makes sense and someone can help - I do have a screen shot but cant see how to attach.
eg: 1 day 'with customer', 1 day 'with support', 2 days 'awaiting information', 2 days 'with support', 1 day 'with customer'
When using a pivot chart it is showing the sum of of the number of days for each status rather than the lifecycle.
I have managed to create the stacked bar chart to show the changing status throughout the lifecycle of the job using my own table but I had to leave separate legend entries for each stage, excel has allocated a different colour for each section of the stacked bar chart even if the label is the same, I can edit the colours so it displays correctly but cannot get the legend bar at the side to assign just one line to each status without it removing it from the stacked bar.
I hope that makes sense and someone can help - I do have a screen shot but cant see how to attach.
