inserting totals on a column chart

J

Joan

hi
i have this spreadsheet that tracks indicators for a project and i display the results in a column char

there are 3 columns, but within each column it is made up of 3 groups i.e. for the hours worked column it is made up of the U.S, Europe and Africa showing the number of hours for each continent

i'm wondering if it is possible to insert the total above or below the column to show the total number of hours worked by all the contents, which is the data changes it is automatically updated like the rest of the char

please hel
joan
 
Top