Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
ashish128
 
Posts: n/a
Default Convert Pivot Table to Normal Data table

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 "Worker and party" as X basis
..
Please Help Me.

  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default Convert Pivot Table to Normal Data table

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:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm


ashish128 wrote:
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 "Worker and party" as X basis
.
Please Help Me.


  #3   Report Post  
Posted to microsoft.public.excel.misc
ashish128
 
Posts: n/a
Default Convert Pivot Table to Normal Data table

Thanks Debra,
Please consider this thread as closed from now

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
OLAP Pivot table - How to show items with no data ? Timmo Excel Worksheet Functions 1 March 30th 06 06:03 PM
Pivot table Data area show/hide behavior Peter Ross Excel Discussion (Misc queries) 0 January 20th 06 10:37 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM
Pivot Tables, Help? Adam Excel Discussion (Misc queries) 6 March 24th 05 02:35 PM


All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"