Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them. Microsoft Excel offers a plethora of tools for ...

Pivot Tables in Excel allow you to analyze and pull important summary information from large data sets. In this workshop, you will learn how to add fields to rows and columns, filters and values. The ...

The way you present your Excel data can make a significant impact on how your message is received. Excel, a tool that most professionals are familiar with, has immense potential for creating visually ...

Excel’s chart features can turn your spreadsheet data into compelling visual communications—if you know what to do. This guide will walk you through the basics of setting up trends, percentages, ...

Transforming your company's financial data into visuals may be old hat after you've added Microsoft Excel's charts and graphs feature to your roster, but those graphics can seem to float in a sea of ...

If you use Microsoft Excel regularly for studying or work that requires a spreadsheet to be filled with data-driven information, then you know it can be quite difficult and time-consuming to decipher ...

If you have the latest version of Microsoft Excel, you might have noticed that the appearance of its charts have improved dramatically compared to the Windows 95-style graphics from older versions of ...

If you understand the definition of a mathematical function, a good way to judge it is that any line drawn parallel to the y-axis intersects with the values in the function’s curve only once. The same ...

You don't have to settle for those boring default chart styles. Use this tip to make your graphs stand out. Excel’s Chart Wizard makes it easy to create and format charts and graphs. By default, ...

Two weeks ago I announced a bad graph contest to try to encourage software vendors to improve their offerings. Readers nominated a number of bad graphs for the contest. This post discusses some of the ...