Author: Joern Steinz

How to create a donut chart in Excel

A donut chart, also known as ring chart, is a special kind of pie chart, that is located in the Excel drop down menu options for pie charts. The donut chart is perfectly suited to visualize data when a single number is important as part of a whole. Preferably the donut chart should show only two numbers in total in order to create a clear message and to communicate the data as effective as possible. How to create a donut chart in Excel step by step Create the table with your data in the form, that all values add up to 100%. Use color strategically to emphasis the message of your chart. To do this, change the color of the less relevant data to grey and the color of the important number to a bright paint (an action color as Stephanie Evergreen from author of Effective Data Visualization calls it). Therewith, the important color will receive the instant attention of the eye. Decrease the size of the hole in the donut chart to bring even more emphasis on the data. Click on the chart area, then right click and chose format data series. Next you may change the ring size to 25% (default settings is 50%) in order to make the ring biggr. Delete the legend and write your legend data in a text box in the graph instead. As a result you may get...

Read More

How to build a project plan in Excel (Gantt Chart)

A Gantt chart is a project plan and one of the most useful project management tools to visualize the required tasks and their respective duration to finish a project. In this article you will learn how to build a Gantt Chart in Excel in a couple of minutes. So let´s get started: How to build a Gantt Chart in Excel step by step First, create a table that list all your tasks of the project with the tasks start dates and the duration of the tasks. For example like the following table (you can download this row data and other samples at our Excel exercises page). Task Start date Duration (days) Task1 09.06.16 10 Task 2 15.06.16 4 Task 3 16.06.16 6 Task 4 16.06.16 12 Task 5 16.06.16 14 Task 6 19.06.16 5 Task 7 27.06.16 4 Task 8 27.06.16 10 Task 9 30.06.16 10 Task 10 04.07.16 1 Task 11 05.07.16 35 Task 12 21.07.16 40 Build a bar chart Next, add a blank bar chart (second chart in the first row of the menu), then right click into it and choose select data Click add series and enter the Start date fields Next repeat the previous steps with the duration and replace the numbers on the axis with the task name Now, click Ok to close light box. Next click on the left axis and select...

Read More

Pivot tables in Excel

Apply table formatting to raw data 2. Insert Pivot table: For Mac: Click in table > data > pivot table > create pivot table manually > select existing worksheet > choose a cell to place the pivot table / For PC: Go to insert > tables > pivot tables Decide first what you want to analyse => bottom right field Decide you column criteria Decide your row criteria...

Read More

Overlapping charts in Excel to compare two things or show one part of the other

Overlapping charts in Excel are a perfect way to visually compare two inherently connected things or to show how much one thing is part of the other. For instance, actual results in comparison to planned results. Creating overlapping charts is simple as soon as you know the tricks on how to tweak Excel for your needs. How to create overlapping charts in Excel step by step Start with a standard table: Next, insert a standard bar chart (best the grouped bar chart) The magic step now is to move one bar on top the other. To get this, click...

Read More
  • 1
  • 2

About Effective Charts is a Storytelling and Slide Design training service to help you build effective presentations. Contact me me for
  • Presentation Design
  • Data Visualization
  • Storytelling
  • Custom Slides and Reports
  • Workshops

Excel tips & tricks mail

Build your own website

Divi WordPress ThemePartner offer