2 Replies Latest reply on Jul 6, 2018 3:16 AM by Mike Gurajek

    Grouping data

    Mike Gurajek

      Hello, I wonder if anyone can help. I have a dataset with age groups. As you can see the in the workbook ages are grouped  nicely, except for ages 15, 16-17, 18-19. Because they are split there is a dip in the graph. I would like to group ages 15, 16-17 and 18-19 and display their sum as a new group called "15 to 19.". Can this be done and if yes, how? I have been trying all morning to no avail. But I am sure someone has an answer