Amy has attended:
Excel Intermediate course
Pivot Tables/ Charts
I am having difficulty formatting my information. Can you send me an example as to where I am going wrong? Thanks
RE: Pivot Tables/ Charts
Dear Amy
By Formatting I assume that you mean the appearance of the Pivot table.
There is a Autoformat feature that you can use to save time shading cells and Autoformat can make your pivot tables look professional within few clicks!!
To do that click anywhere inside your Pivot Table .
Click on the Auto format button on the Pivot Table Toolbar (or you can also choose [b]Format > Auto format
Attached files...
Autoformat samples PivotTable.xlsRE: Pivot Tables/ Charts
Dear Rajeev,
I was not very clear.
I need to know how to build a pivot table/ graph and what sort of information do I use to build one?
Thanks,
Amy
RE: Pivot Tables/ Charts
Dear Amy
Sorry for the delay in responding!!
The main purpose of creating Pivot Table is to summarize your data. Although the same result can be achieved via Auto filters but the main advantage of Pivot Tables is that it can perform various functions such as Sum, Count Min, Max and Average and is Interactive which means that you can simply drag the column headings to the appropriate areas in the Pivot and it does summarizes that data. You have the option of displaying the fields' headings either as rows or columns!!
The answer to your question about what type of data do you require to create a Pivot Table is that it doesn't really matter!! You should have some numeric data to perform calculations.
You can create a chart based on the pivot data by a simple click!!
Please follow these steps to create the Pivot table.
Step 1. Click inside the table that the Pivot Table is to be based upon.
Step 2. Select [b]Data > Pivot Table and PivotChart Wizard
