I have a simple data set with nine values in Google Sheets. (Link here, screenshot follows.)
Some questions about charts (Mockup at bottom):
- I can concatenate Columns A and B into a new column to get a joint label that includes both. Is there an easier way?
- I can give distinct colors to every bar separately, with "Format Data Point". Can this be automatically based on Column A/B?
I can add labels by selecting "Data labels", but can I add this additional unit information (hours/minutes, taken from Column D), as in the mockup?