## How to Make a Pie Chart in Excel

Sometimes, you need to make a pie chart in Excel. No, it’s not the best way to present data, but sometimes you have to go with the chart type that someone else chooses.

Maybe your boss is demanding that you make one for the annual report. Perhaps your professor is basing 50% of your final grade on building the perfect pie chart. Your sister needs help with a report for her dessert of the month club, and a pie chart seems okay for that!

So, if you’ve never built a pie chart in Excel, or it’s been so long that

Continue reading How to Make a Pie Chart in Excel

## Create an Excel Line Chart with Target Range

With an Excel line chart, you can show the sales results from a date range, to see how things have gone. For example, in the chart shown below, you can see the sales quantities for the first six months of the year.

To give a better picture, you might also want to show what the sales targets were for each month of the year.

In the next chart, a blue band with the target range has been added, and you can quickly see which months were over or under the target amount.

Set up

Continue reading Create an Excel Line Chart with Target Range

## Change the Default Chart Type in Excel

On July 25th I announced a giveaway for Jon Peltier’s amazing Chart Utility, and thanks for all the entries! The deadline was yesterday, August 5th, at 12 noon Eastern time, and the winner of the random draw is:

Krystal, who posted comment #11.

Congratulations, and Jon will send you an email to arrange the delivery of your Chart Utility. You’ll have 24 hours to reply to his email.

Chart Utility Discount

If you didn’t win the giveaway, Jon has provided a coupon code that you can use to buy the Chart Utility at a 15% discount.

Continue reading Change the Default Chart Type in Excel

## Excel Charting Utility Giveaway

Last week, you had a chance to win John Walkenbach’s new book – 101 Excel 2013 Tips, Tricks & Timesavers, thanks to Katie Mohr at Wiley. Thanks for all your comments – those were great tips! And the winning entry, chosen in a random draw, in Excel, of course, is:

Neil, with comment 22.

Congratulations Neil! After Katie sends an email to Neil, he has 24 hours to claim the prize. If not claimed, we’ll go to the next name in the randomly sorted list.

This Week’s Giveaway – Excel Chart Utility

This week, you’ll have a chance to win

Continue reading Excel Charting Utility Giveaway

## Create a Simple Box Plot in Excel

A box plot (box and whisker chart) lets you show how numbers are distributed in a set of data. Excel doesn’t have a built-in chart type for a box plot, but you can build one yourself, using a stacked column chart, and error bars.

Do the Calculations

To build a box plot, you’ll need to do a few calculations for each set of data: Min, Quartile 1, Median, Quartile 3, and Max.

From those calculations, you can figure out the height of each box, and the length of the whiskers. The diagram below shows where each measure appears

Continue reading Create a Simple Box Plot in Excel

## Click to Show or Hide Excel Chart Data

If you’re building Excel reports for other people to use, you can add a few interactive chart features, to let people customize the reports.

In this example, there is a check box beside each region name, in the sales summary table.

If you add a check mark, that region’s data is shown in the chart. If you clear the check mark, the region’s data disappears from the chart.

This is based on a technique that I learned from Jon Peltier, who creates amazing Excel charting utilities.

No Programming Required

There’s no programming required for this technique – the chart

Continue reading Click to Show or Hide Excel Chart Data

## Show Excel Sparklines for Hidden Data

Do you use the sparklines that were introduced in Excel 2010? Last week, I was building a dashboard, and wanted to show sparklines for expenses and revenue.

It didn't go smoothly at first, but I finally got things working, and then I ran into another hurdle!

Here's what went wrong, and how I fixed things.

Create a Sparkline Group

In this example, I had expenses and revenue in alternating columns, and I wanted expense sparklines in cells C4:C14. So, I selected those cells, and on the Ribbon's Insert tab, click the Line command in Sparklines.

In the Create Sparklines

Continue reading Show Excel Sparklines for Hidden Data

## Compare Word Counts in Excel Chart

It's week two in the free online Infographics and data visualization course, led by Alberto Cairo, and I'm working on this week's assignment.

The discussion this week is about a New York Times graphic that shows the number of times that words were used at national conventions. The words are shown in blue and red (pink?) bubbles, representing the party colours, and you can add other words to the graphic, to see how they fared.

If you click on a circle, the selected word is shown in context, below the graphic, in various speeches.

Improvements to the Infographic

Continue reading Compare Word Counts in Excel Chart

## Link Pivot Chart Title to Report Filter

Recently, I enrolled in an online Infographics and data visualization course, and the classes started last week.

The instructor is Alberto Cairo, who wrote The Functional Art: An Introduction to Information Graphics and Visualization.

He uploaded the first two chapters of his book for us to read during week one, and I really enjoyed it. There was some history, some theory, and plenty of graphics, to illustrate the text.

Improve the Infographic

One of the assignments this week was to suggest improvements to an infographic on Social Web Involvement. There are 16 countries in the infographic, overlaid on a world

## Create a Line Column Chart on 2 Axes in Excel 2010

When you create a chart in Excel 2010, you can select a chart type on the Ribbon's Insert tab.

For some charts, instead of selecting one type, you might like to combine two different chart types, like the line-column chart shown below.

The Old Chart Wizard

In Excel 2003 and earlier versions, there were combination chart types available in the Chart Wizard. You could click on one of those, to quickly create your combination chart.

In Excel 2010 and Excel 2007, these combination charts, such as Line-Column and Line-Column on 2 Axes, aren't available in

Continue reading Create a Line Column Chart on 2 Axes in Excel 2010