Grouping together data points on a bar chart by colour

[LH8568]

Hi,

My task is to track temperature of certain points according to shift. There is approximately 12 shifts (6 days and 6 nights) and 8 data points in each. The don't have to be different colours, say red (days) blue (nights). I can't seem to group them together to fill them.

I also want to have each 8 data points assigned to one date on the horizontal axis where the temperature is on the vertical axis, is there a way of doing this?

Thanks for your help

[dflak]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.