close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()