Category: Charts
Create a 3-D Power Map in Excel
Microsoft’s latest release of Excel has some powerful updates. Our latest 2016 highlight is the popular Power Map add-in. This feature can plot geographic and temporal data on a globe or custom map in a three-dimensional presentation. You can view data changing over time and create animated presentations called “tours”.…
Read More
How to Create a Secondary Axis Excel Chart (AKA Dual Axis Chart)
If you have two data series that are related, but not comparable, it might be tough to chart it. For example, let’s say you have data representing the sales of products. You also have the production costs. When you subtract the production cost from the sales data, you get the…
Read More
How to Create an Excel Gauge Chart (AKA Speedometer Charts)
You might think you need some fancy add-ins to create charts that look like a speedometer. In this tutorial, you’ll learn how to create this snazzy image from a pie chart and a doughnut chart. Download CreatingGaugeChart.xlsx to follow along. The Steps Create the data for the speedometer. If a…
Read More
How to Create Excel Graphs Templates
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…
Read More
Interactive Excel Charts: Create a Chart Selector
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.…
Read More
The Guide to Animated Excel Graphs
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…
Read More
Use Multiple Worksheets to Create 3D Excel Charts
A 3D Excel formula allows you to calculate cells across multiple worksheets. It is incredibly useful for creating a summary sheet to share data with others. You can then share the results visually with the help of a 3D Excel Chart. Download and follow along with 3D Excel Charts.xlsx. Step-by-Step:…
Read More
The Right Way to Create an Excel Rolling Chart
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…
Read More
How to Make a Radar Chart in Excel
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…
Read More
Export Excel Charts to Word and PowerPoint Using Copy/Paste
Once you have spent the time crunching numbers and creating a beautiful chart in Excel, you'll probably find that you want to use it again and again in reports and presentations. Microsoft makes it easy to share objects between its Office programs, but few methods are easier than Copy/Paste. We…
Read More