Bar graphs are graphical representations of statistical data in the form of strips or bars. This allows viewers to understand the difference between the various parameters of the data at a glance ...

Have you ever struggled to make sense of a dataset with too many categories or time-based data? It’s a common challenge—how do you present individual contributions while still showing the bigger ...

The Gap Width option in Excel for Mac 2011 controls the spacing of bars in a column graph. Decreasing this percentage shrinks the empty space between columns by widening the columns themselves.

The ease with which you can create a line graph in Excel on your PC or Mac will do much to dispel the misconception that the program is arcane and unapproachable. With just three clicks of a mouse (or ...

Tired of erasing holes in your graph paper or having to start over from scratch? Here's an easy way to create your own custom graph paper in Excel. This past week, I started mapping out new flowerbeds ...

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

How to split a column using an IF() function in Excel Your email has been sent We all inherit Microsoft Excel sheets that don’t suit our working routine. If it’s a simple tracking sheet of some sort, ...

Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.