Grand Totals in pivot grids

Can you tell me how to remove the grand totals to the right and bottom of a pivot grid? I’ve tried everything I can think of and nothing works.

On the Chart part of the window there is a toolbar with a drop down with Chart Selections. You can de-select the totals.

Debbie

Debbie -- I tried that but it didn't work. Here's a screen shot of my pivot grid.

Vicki

Try selecting all of the rows. I think by default the grid selects the first row and that is what you are seeing in the graph.

I also have the same question - I posted a separate thread about pivot grids and still can’t figure out how to get rid of the grand totals on the pivot grid section, not the chart. I removed the sum totals from every column in my grid, but that did not work. I also don’t see a totals options section in the setup grid window. Is there not a way to get rid of the grand totals?