Hi,
Trying to represent some data as a stacked bar chart. Hoping to have each stack colour co-ordinated to a legend and labled by the colour code.
The data I have monitors hours for an asset at a warehouse in a specific location. For example:
Location hours worked Operator -------> Legend (colour and code)
Africa 2.3 hours Steven Yellow, "S" Africa 1.3 hours Paul Red, "P"
Australia 6 hours Steven Yellow, "S"
Europe 3.4 hours Greg Grey, "G"
Africa 1 hour Greg Grey, "G"
How do I set up the data such that I can have a stacked bar chart with Location on the x axis, hours worked on the y axis and the have each stack coloured and or coded eg stack is yellow with the letter S inside.
Any help will be much appreciated.
Thanks
Trying to represent some data as a stacked bar chart. Hoping to have each stack colour co-ordinated to a legend and labled by the colour code.
The data I have monitors hours for an asset at a warehouse in a specific location. For example:
Location hours worked Operator -------> Legend (colour and code)
Africa 2.3 hours Steven Yellow, "S" Africa 1.3 hours Paul Red, "P"
Australia 6 hours Steven Yellow, "S"
Europe 3.4 hours Greg Grey, "G"
Africa 1 hour Greg Grey, "G"
How do I set up the data such that I can have a stacked bar chart with Location on the x axis, hours worked on the y axis and the have each stack coloured and or coded eg stack is yellow with the letter S inside.
Any help will be much appreciated.
Thanks
