Pivot Chart Total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot chart with 2 data series.
What is the best way to calculate the totals for both series and display it
on the form. I was thinking a text box with a calculation in it or
something.

My chart shows the total sales for each agent at my company. It is a
stacked bar chart. One data series is Fees and the other is called Add-Ons
(extras that they were able to charge for)

Any help would be appreciated. Thanks!
 
Just to be more clear, I'd like to basically add up all the numbers on the
chart and show them. This number should change when the user filters the
data differently, etc.
 
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

Multi Axis Pivot Chart 12
Pivot Chart - adding Grand Total to chart 0
Stacked Bar Chart 1
hide Drop Series Fields Here 5
Pivot Table Chart? 4
Pivot Chart with two series 0
Pivot Chart Refresh cancels all chart formatting 2
Pivot Chart - negative values not displaying properly 2

Back
Top