CODEWITHSUNDEEP
google-sheets
Petricc-
Petricc-

Reputation: 1

Combine different rows in a chart as one value (google sheets)

For a project I need to show how many hours have been worked by teams on days. The chart needs to contain the days of the week. Monday to Sunday. A day can have multiple rows because the location can differ and a team is full when two employees have registered to work. When full a new row will be created with the same day. My challenge is to show the amount of hours in a chart as one day per weekday instead of showing multiple days with the corresponding working hours. There is no option to manually calculate all the total working hours per day. Is there an other option available to combine the output of the same days? For example: monday monday monday (3 rows) need to be shown as one in the chart.

Thank you for helping!

Upvotes: 0

Views: 903

Answers (1)

Shub
Shub

Reputation: 468

  • Click on Inset -> Chart. Click on chart and new menu will pop-up right of screen. Here you can select type of chart and customize it according to your requirements.

Upvotes: 1

Related Questions