Total $ of data chart

**bpkowalski** · 10-28-2011, 04:14 PM

I have attached a chart that was recently requested. The data is included in the workbook. I have to total each of the horizontal label (milestone, hosting, etc). How do I do that without having to have a separate cell like I am currently doing or having the data charted

thanks for the help!

**teylyn** · 10-28-2011, 08:40 PM

Hello,

the problems arise from the unfortunate data layout. Use a flat table with the columns

project, fiscal year, date, category, Projected, Actual

Then you can build a pivot table from that data and the results are automatically summed. See attached, sheet 2

cheers,

**pmalen** · 10-29-2011, 11:01 AM

Here is another option that preserves your layout. I only changed the cells in green.

**teylyn** · 10-29-2011, 05:33 PM

pmalen, as I understand the question, it was not about what formula to use but how to avoid having to enter a formula at all. The pivot table is the only option that avoids having to insert a separate column for totals.

**pmalen** · 11-01-2011, 09:36 AM

Originally Posted by teylyn

pmalen, as I understand the question, it was not about what formula to use but how to avoid having to enter a formula at all. The pivot table is the only option that avoids having to insert a separate column for totals.

You are correct. My bad.