Normal Chart From Pivot Table Data

blatham

New Member
Joined
Nov 8, 2005
Messages
47
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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

srburk

Board Regular
Joined
Mar 25, 2002
Messages
154
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.
 

Forum statistics

Threads
1,136,596
Messages
5,676,712
Members
419,646
Latest member
ReneeDJ73

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top