Anatomy of Excel data analysis: Advanced graphs and PivotCharts
Sometimes we take for granted what users know. While Microsoft Excel may be familiar to you, if you are on a help desk you will have to explain how the application works to users that fall within a vast range of skill level and knowledge. This series of Excel tutorials can make that training much simpler. This installment of the series shows you how to use the graphing component related to Excel's PivotTable feature: PivotCharts.
Microsoft Excel spreadsheets are an excellent way to communicate numerical and statistical information, but sometimes pure numbers can be overwhelming, especially for more general audiences. This is where graphing can help, because it can emphasize the particular bit of information you want the audience to see and focus on. This download, Part 11 of the Anatomy of Excel series, explains how to use the graphing component related to Excel's PivotTable feature: PivotCharts.This download tutorial deals with Excel graph functions, but there is so much more to learn. What aspects, functions, commands, and/or features would you like to see covered in future installments of the series?
You can get access to the entire Excel series using this link to the excel anatomy tag.
This download is also available as a TechRepublic article.