Excel 2010: Line Graph & Column Bars [Sparklines]

Excel 2010 includes a feature of analyzing data through Sparklines and Column bars, this could be very beneficial if you want to see the trends, and comparisons of each record in pictorial representation. It actually summarizes one complete record and shows it in a single cell through simple line graph and column bars, this post covers the basic usage and elaborates how they logically relate with the data. Read More

Microsoft Excel 2010 Data Bar

Introduction

Just like Sparklines, Data Bars are also a way to represent data graphically inside the cell. They provide a way to show values visually using bars within the cells that contain values. The Data Bar feature was included for the first time in Microsoft Excel 2007.

Read More

Excel 2010 Sparklines

Introduction

Sparklines are mini-charts that you can place inside cells in order to view the data and the chart on the same table. In older versions of Microsoft Excel, third party add-ins were used to serve this purpose, but the latest Excel versions have embedded this functionality for the user’s convenience.

Read More

Microsoft Office Excel 2010: What’s New?

Microsoft Office 2010 has revealed many outstanding features, we are continuously covering that latest additions and tips. You can read a summarized post on both Microsoft Word 2010 and Microsoft PowerPoint 2010. Today, we will see what new additions have been added to Microsoft Excel 2010. Although, it is a fact that Excel hasn't been touched as much as the other major applications in Office 2010, there are still some amazing additions in it. Lets explore them: Read More