ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Creating a Pivot Table (https://www.excelbanter.com/charts-charting-excel/29383-creating-pivot-table.html)

lkw441

Creating a Pivot Table
 

I want to create a pivot table. I have a field named 'Description'.
There are various machines within. I would like to have a chart that
tells me how many P2 266s that I have, how many, P3 500s.......etc.
Unfortunately, I cannot find my answer when I go to the HELP menu of MS
Excel. Any help would be appreciated. Thanks a lot.

Larry


--
lkw441
------------------------------------------------------------------------
lkw441's Profile: http://www.excelforum.com/member.php...fo&userid=2622
View this thread: http://www.excelforum.com/showthread...hreadid=376842


Tushar Mehta

Put the 'Description' as both the row field and the data field.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I want to create a pivot table. I have a field named 'Description'.
There are various machines within. I would like to have a chart that
tells me how many P2 266s that I have, how many, P3 500s.......etc.
Unfortunately, I cannot find my answer when I go to the HELP menu of MS
Excel. Any help would be appreciated. Thanks a lot.

Larry


--
lkw441
------------------------------------------------------------------------
lkw441's Profile:
http://www.excelforum.com/member.php...fo&userid=2622
View this thread: http://www.excelforum.com/showthread...hreadid=376842




All times are GMT +1. The time now is 11:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com