Excel® Tips and Tricks

Category: Charts

Get the best in Excel® training anytime, anywhere.

Get Excel® Training

How to Create Excel Graphs Templates





Categories: Charts, Excel®

We might not normally think of creating templates for Excel charts and graphs. But if you’re a frequent user of the charts feature in Excel, you may spend quite a bit of time getting the colors, appearance and elements of a chart just right. Who wants to keep doing that over and over?! You can […]

Read More

Interactive Excel Charts: Create a Chart Selector





Categories: Charts, Excel®

More and more data has led to more and more opportunities to present it in visually understandable ways. However, it can get frustrating having to navigate through a large workbook, just to find the exact chart you need. In this tutorial, you’ll learn how to create an interactive chart selector. If you aren’t familiar with […]

Read More

Animating Excel Charts





Categories: Charts, Excel®

There are a lot of cool new tools in the latest professional versions of Excel that allow you to add some animation to your charts and graphs. However, with a little help from PowerPoint, you can do some types of animation in almost any version! While animating chart data can seem a nifty thing, please […]

Read More

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