Excel 2007 : Secondary axis, create grand total bar

[tecolote12]

Hi!

Here’s what I’m trying to do. The lines in the chart are good. What I want to do is add the total count for the bars (per month on the horizontal axis) so it’s a grand total per month. (see attachment of a pivot chart linked to pivot table). basicallt, my "Percent of volume" I want displayed on the graph is the sum of all "0-7" "8-14" and ">14".

Thanks.

[tecolote12]

sorry, correction: my "# of units" should be the sum of all "0-7" "8-14" and ">14".

Thanks again.