Normal Chart From Pivot Table Data

[blatham]

Hi

Does anyone know if it is possible to create a normal chart based on the data in a pivot table (ie not the pivot chart that is brought up by default)?

Or any cunning ways round it?

I have a pivot table with various fields in the Page area that I would like the user to available to select from and have charts based on certain fields in the pivot table body that update automatically.

Cheers

 

[PaddyD]

I think Tushar just about covered it:

http://www.mrexcel.com/board2/viewtopic.php?t=236879&highlight=pivot

 

[srburk]

For me, I had a simple formula =SUM(D3-E3). What appeared was 5 but if I were to push out the decimal, I would see 5.123454.

When I tried to pivot all of the data, it showed me 20 different rows of 5.

I fixed it by rounding my original data. Now the original formula says, =ROUND((SUM(D3-E3)),1) where the one means to round it to the nearest one integer.

The pivot table works great now.