Make a Better Pizza Pie Chart

pizza pie chart

While flipping through a magazine on the weekend, I saw this pizza pie chart. Yes, the pizza looks delicious, but the toppings are split down the middle. That makes the vote appear to be 50-50, not 58-42. Fun idea, but bad chart!

The picture was making me hungry. I didn’t want to ruin my dinner, by going out for a pizza snack, so I decided to make a better pizza pie chart in Excel.

Continue reading Make a Better Pizza Pie Chart

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

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

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

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.

Add a Target Range

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

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

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.

Click this link

Continue reading Change the Default Chart Type in Excel

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

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

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest

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

Related Posts Plugin for WordPress, Blogger...

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest