Hi Everyone,
I made a Pivot table (sucess fully) but I am unable to make a
customized chart out of it.
My Pivot Table is
Sum Of OK Pcs Date
Worker/Party 1 3 4
Ashish Bhasak
Ashutosh Dwivedi
Gopal Lal
Govind Ram Prajapat
Hari Singh Meena 2525 1448
Mohammed Ali 816 4181
Mukeah Kumar Kachot
Raghuvir Singh
Grand Total 2525 2264 4181
I want to make a chart with taking only the date values (i.e 1,3,4) and
Grand Total (i.e. 2525,2264,4181) But It is always creating a pivot
chart with taking the values of quot;Worker and partyquot; as X basis
..
Please Help Me.The Grand Total doesn't appear in a pivot chart. You could create a
normal chart, based on the pivot table, and include the totals in that.
On Jon Peltier's site, there are instructions for creating a normal
chart from pivot data:
www.peltiertech.com/Excel/Pivots/pivotcharts.htmashish128 wrote:
gt; Hi Everyone,
gt; I made a Pivot table (sucess fully) but I am unable to make a
gt; customized chart out of it.
gt; My Pivot Table is
gt;
gt; Sum Of OK Pcs Date
gt; Worker/Party 1 3 4
gt; Ashish Bhasak
gt; Ashutosh Dwivedi
gt; Gopal Lal
gt; Govind Ram Prajapat
gt; Hari Singh Meena 2525 1448
gt; Mohammed Ali 816 4181
gt; Mukeah Kumar Kachot
gt; Raghuvir Singh
gt; Grand Total 2525 2264 4181
gt;
gt; I want to make a chart with taking only the date values (i.e 1,3,4) and
gt; Grand Total (i.e. 2525,2264,4181) But It is always creating a pivot
gt; chart with taking the values of quot;Worker and partyquot; as X basis
gt; .
gt; Please Help Me.
gt;Thanks Debra,
Please consider this thread as closed from now
- Oct 05 Fri 2007 20:40
Convert Pivot Table to Normal Data table
close
全站熱搜
留言列表
發表留言