Excel® Tips and Tricks

Category: Charts

Get the best in Excel® training anytime, anywhere.

Get Excel® Training

The Right Way to Create an Excel Rolling Chart





Categories: Charts, Excel®

Creating reports on a regular schedule is a common task for the business Excel user. When you need to create a Rolling chart that reflects data in a specific timeframe – such as the previous 12 months – you can quickly find yourself in a maintenance nightmare, updating your charts manually to include the new […]

Read More

How to Make a Radar Chart in Excel





Categories: Charts, Excel®, Uncategorized

Pie charts, bar charts and line charts are familiar friends to Excel users. But there’s a less well-known chart out there that can pack a lot of information into a single, visually powerful image. The Radar Chart, also sometimes called a spider or star chart, lets you compare multiple items against multiple criteria. You could […]

Read More

How to Create an Excel Funnel Chart





Categories: Charts, Excel®

If you work in sales, marketing or any department that uses/receives reports from Business Intelligence software, you’re probably familiar with the Sales Funnel Chart. If you are looking to create a funnel chart of your own, you might find that it’s a bit of a trick. Excel gives you the tools to create the iconic […]

Read More

Create Outstanding Pie Charts in Excel





Categories: Charts, Excel®

Once you have gone to the effort of collecting, organizing and processing your data, you probably want to show it off! Tables do a nice job of presenting raw information, but a chart can bring your data to life. Charts create visual impact that conveys not only the data itself, but its relationships and meaning.

Read More

Working with Multiple Data Series in Excel





Categories: Charts

One of the most powerful advantages of a chart is its ability to show comparisons between data series, but you’ll need to spend a little time thinking about what you want to show and how to organize it for excellent communication. Let’s look at the ways that Excel can display multiple series of data to […]

Read More

Three Excel Chart Add-Ins to Create Unique Charts and Graphics





Categories: Charts

There’s no debating that Excel is a powerful, useful tool for gathering, analyzing and communicating all kinds of data. But even the biggest fan sometimes wishes for just a little bit more, especially when you want to create visual impact for your data in charts and graphics. Microsoft opened the door for developers and third […]

Read More

Creating a Radar Chart in Excel





Categories: Charts

Sometimes it is very useful to see the magnitude of many variables for several different independent variables in one chart. The easiest way to do this is to create a radar chart, also known as a spider chart or web chart in Excel. A radar chart in Excel is set up like a wheel with […]

Read More