Pivot Table Resutls Don't Match the Graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ashley - 03 Jul 2009 22:24 GMT

Hi Everyone!

I have three pivots and one pie graph all on one worksheet. Now, one of
pivots is supposed to generate the data into the pie graph and break it down
into percentages. However, for some reason the percentages from my pivot
don't match my graph. I tried looking at the decimal point in the pivot and
it appears that Excel isn't rounding the numbers correctly so that they match
the graph. Does anyone know why this might be happening?! Please help!

Reply to this Message

Shane Devenshire - 04 Jul 2009 00:40 GMT

Hi,

Not enough detail. So what is one of the values in the pivot table (as
displayed on the formula bar) that is not displaying correctly? And how is
it displaying in the pivot chart? Are you plotting the %'s that are in the
pivot table or are you doing a pie chart and letting Excel add %'s in the
chart?

First, the pivot table does not round numbers by default all calculations
are out to 15 decimal places.

Signature

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

> Hi Everyone!
>
[quoted text clipped - 4 lines]
> it appears that Excel isn't rounding the numbers correctly so that they match
> the graph. Does anyone know why this might be happening?! Please help!

Reply to this Message

Ashley - 06 Jul 2009 15:31 GMT

Hi,

I apologize that I wasn't more clear before. For example, the pivot table
shows a percentage of 39.695 when I ask it to show the decimal places.
However, when I take away the decimal places, it rounds correctly to 40%.

The chart however, still shows 39%. Do you know why this might be happening?

Thanks everyone for all your patience and help!

-Ashley-

> Hi,
>
[quoted text clipped - 15 lines]
> > it appears that Excel isn't rounding the numbers correctly so that they match
> > the graph. Does anyone know why this might be happening?! Please help!

Reply to this Message