• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using OLAP PivotCharts

A PivotTable full of numbers is a good way to see details but is not always the best way to see the big picture. Excel charts are a great way to get an overview of your data at a glance and to reveal hidden information. Pie charts, bar charts, and area charts are good for demonstrating proportions and contributions to the whole of individual dimension elements. Bar charts and line charts are good for revealing trends, particularly across a time dimension. Excel PivotCharts complement PivotTables to provide advanced visual analysis of OLAP data.

Note

For more information on charts, see Chapters 2023. For more on PivotTables, see Chapter 24.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint