| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| Pivot table Data area show/hide behavior | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Threaded Mode
