Tuesday, February 9, 2010

Excel Pivottable Change Table Range How Do I Show The Data On My Excel Pivottable?

How do I show the data on my excel pivottable? - excel pivottable change table range

I insisted on the two columns of data that you want to use. Then she went on to create the PivotTable. I took my two classes of data and to the upper left corner, assigned by my desk. I can not add data to a part, "Drop data items here says." When I double click on a cell opens a new worksheet that displays the data associated with this cell.

1 comment:

kezzybea... said...

They have a link to "count" for the series information.

I do not have Excel before me for the exact instructions, but you should get a popup window when you click on a button box that clicking a drop-down list where you have rows or columns, etc., can select and then click an item in the list in the white area above link information in the PivotTable.

Somewhere out there (or in the pivot table), you must tell the pivot table "Count" data.

I'm sorry so vague. =.-)

Post a Comment