Charts

CHOOSE the RIGHT Chart Animation in PowerPoint

CHOOSE the RIGHT Chart Animation in PowerPoint Have you ever been tasked with presenting a chart or a graph in a meeting? If you are using PowerPoint during the presentation, the way you setup the PowerPoint slide matters. Let’s look and a

Excel Data Entry Form

SUPER EASY Excel Data Entry Form (NO VBA) In this post we will look at creating data entry forms in Excel. The best part is… NO VBA! Suppose you need to input data into an Excel table and you want to make

Charting Survey Results in Excel

Charting Survey Results in Excel (Visualize Employee Satisfaction results) This post spotlights a practical way to visualize survey results in Excel, particularly surveys that follow a “like/hurt” format.  Surveys, like employee surveys, that provide a range of choices between “Strongly Disagree” to

Highlight Max & Min Values in an Excel Line Chart

Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts) Is it possible to call attention to the highest and lowest values in a line chart dynamically?  Can we color or accent these values in the line chart

3 Handy Excel Chart Tips You Might Have Missed

3 Handy Excel Chart Tips You Might Have Missed This post will focus on three little-known chart features that will save you time when creating reports include charts. Let’s see how many you know versus how many are new to you.

Creative Infographics in Excel

Creative infographics in Excel(Male, Female icons) Using fillable icons on charts is a good way to visualize data. In this example, the male and female icons will be used. To do this:Set up the data tableInsert a clustered column chartInsert icons into the chartFormat

How to create a Step Chart in Excel

This tutorial is a Step by Step approach to creating a Step Chart in Excel from Scratch. You can also download the template from the link below. What is a Step Chart? A Step Chart is great for visualizing variables that change on an

Infographics in Excel: NOT your Usual Bar Chart

In this tutorial you learn how to create a bar chart that includes the male/female icon in a dynamic way. Let's assume you'd like to show the percentage of male/female visitors to your store - and you'd like to show it, like the image

Excel VBA: Control WordArt Fill with Macros

How can you get this effect? Find out how you can use Excel Macros to control the fill color of Word Art in VBA. In this specific case we have a dynamic Word Art which shows a percentage value that is connected to a