Adding totals to Data Tables on Graphs

Anonymous
2016-04-04T15:46:38+00:00

Hello,

I am adding charts to report. I am using cluster column charts to show how many activities were completed (x axis) for each district (y axis).  I have included a data table below the chart.  Below is what my chart looks like.

Is there any way to add the total for each year to the table without graphing the total?

Thanks,

David

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes
Answer accepted by question author
  1. Anonymous
    2016-04-12T14:11:51+00:00

    Thanks for your response Doug but I think we figured it out. I was able to include a formula in header column to total each row. Not ideal but served the purpose.

    Thanks again

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Doug Robbins - MVP - Office Apps and Services 322.1K Reputation points MVP Volunteer Moderator
    2016-04-05T00:27:28+00:00

    If you want to send me a copy of the document, or that part of it, I will see what can be done.

    0 comments No comments