Dynamic sum in Chart

  • Thread starter Thread starter Misha
  • Start date Start date
M

Misha

Hello:

So I've got this pivot chart that I've created, and it's great, EXCEPT
when I select different categories to show up, I want to show a SUM of
the categories, not the values of each category. I would appreciate any
help/advice you may have.

Thank you!

Michelle
 
In the pivot table you can select different thing like count and SUM
etc. If you right click in the upper left vacant square and chose field
settings, then select what you want to see in your data section.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with excel 2007 chart 5
Chart Title change with Drop Down Selection 2
Blank Charts and Paste Special 5
Calculating the Sum of Drop-down list content control values (vs. display) 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Dynamic Range Chart and Ignoring Zeros 3
Stacked Bar Chart 1
problem with an Excel chart 1

Back
Top