• 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 Chart Formatting

F

Frank Bacchus

Member
I have a pivot chart where I am tracking low, medium and high issues for several support staff members. In this chart I am showing the average number of days that the support member is taking to close the issues in the low, medium, high category. That's all fine and I am able to show the number of days in the graph. What I can't show, is the number of issues the pivot chart is using to determine the average. So if there are 4 issues and each is taking 5, 6, 7, 8 hours to close, the average time is 6.5 hrs and the number of issues is 4. I would like to show in the chart 6.5, 4. Can this be done? Thank. See attached.

frank
 

Attachments

Dear Frank Bacchus,

You can drag days to complete into Values area again.
Change the value settings to count and place it before average.

I have enclosed the file for example.

with best regards,

Arun N
 

Attachments

narunfca said:
Dear Frank Bacchus,

You can drag days to complete into Values area again.
Change the value settings to count and place it before average.

I have enclosed the file for example.

with best regards,

Arun N
Click to expand...

Thanks Arun. I was looking for something a little differently and have demonstrated it on my attached Sample file. Basically, I used Alicia as an example:
I amended the Data Labels to demonstrate what I was referring to - It shows the averages and I amended it to show the number of issues Alicia closed which derived the averages. In this case the averages were 3.5 and 4.3 days and I added 4 & 6 manually to representing the number of issues she closed in those average periods. Please let me know if this clarifies it.

Thanks

frank
 

Attachments

Hi:

Find the attached. Its not very easy to assign customized data labels on your chart without helper column. You will have to set this up manually once after that the process is more or less automatic. Here is the file I have set this up for you. You may want to give a search on Google how to customize data labels for a chart to learn about the method I have used.

Thanks
 

Attachments

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