• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Charts and how to display averages. Is this possible?

C

cubs610

Member
Hi Everyone,

I am trying to figure out a way to include an "average" line in a pivot chart and have attached a generic file that I am using with a pivot table in a separate worksheet.

This file has report data, which I am using to create the pivot table and am trying to show an average line in the pivot chart. This average line would be for a normal amount of call I get at work.

Thanks again for your time, help and consideration.

-Dave

NOTE: I inadvertently posted the same thread in the general category. My bad... clicked the wrong section and didn't notice it.
 

Attachments

  • Service Desk tickets for Feb to 3-10 - Copy.xlsx
    28.8 KB · Views: 6
Hi Dave ,

First , can you say which definition of average would be the correct one ?

The attached file has 3 ways of calculating the average number of calls. Which is correct ?

Narayan
 

Attachments

  • Service Desk tickets for Feb to 3-10 - Copy.xlsx
    29.3 KB · Views: 4
Hi Narayank991,

Thanks for your help and sure let me provide some more info.
The average that I was looking for is based on an average of the tickets that come in for a particular date range. I am now doing reporting and average ticket count is based on the date criteria.

Hopefully I am explaining myself. Let me knew if I am not and I'll figure it another way.

Thanks,
Dave
 
You must log in or register to reply here.
Back
Top