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?

    sheet as-is mockup

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.