Posts Tagged 'Pivot Table'

How to Make Pivot Charts in MS Access

In this article we look at the steps involved in creating Pivot charts in MS Access in quick time. You might already be aware of the charting feature in MS Excel, but MS Access too, comes built in with a great charting feature. The basics of both these are pretty much the same and Access has some brilliant charting tools. You need Pivot Charts when you wish to do an interactive analysis. A Pivot Chart is simply a graphical representation of the data in a Pivot Table. There are two types of...

Read more »

How to Group or Ungroup Data in a Pivot Table in Your Excel Worksheet

Pivot table can help us manage large data and information. In this article, we will introduce how to group or ungroup data in a pivot table. There are many useful features in pivot table. And those features make the pivot table a very useful tool for data analysis. The image below shows the pivot table in a worksheet. The first column is the date of the range. By default, they will all be listed in the column A. But if you need to know the sales volume in a certain period, such as in a...

Read more »