Excel Tips & Tricks

How to Make a Histogram

A histogram is a distribution graph that allows you to see how several measurements fall within set ranges, or bins, of the dependent variable. A histogram is usually depicted as a bar chart, with one bar representing the count of … Continue reading

Share
Posted in Editing Charts & Graphs, Excel Tips & Tricks | 2 Comments

Making a Small Multiples/Panel Chart

Read more about how the use of small multiples can help you to communicate complex data by using small multiples in my newsletter “Small Multiples — Big Clarity“. Regular Chart Making the Chart Step 1: Create Antibiotics Chart. Select the … Continue reading

Share
Posted in Excel Tips & Tricks, Graphs | 1 Comment

How to Make a Bullet Graph

Making the Chart Step 1: Create your chart. Select cells E5 through G6 and select the “Insert” tab and in the “Charts Section” click the down arrow under “Bar” and select the first selection under 2-D bar for “Clustered Bar” … Continue reading

Share
Posted in Excel Tips & Tricks | 2 Comments

Making a Box and Whisker Plot in Excel

Making a Box and Whisker Plot Getting the Data Ready Step 1: Prepare the Data for the Chart. Insert several blank rows to set up range for calculations. This is represented by cells A16 – G24 in the example above. … Continue reading

Share
Posted in Excel Tips & Tricks, Graphs | 33 Comments

Making a Pareto Chart in Excel

A Pareto Chart is a type of bar chart in which various factors that contribute to an overall effect and are arranged in order of magnitude of their effect. Sample Data Table:Types of Errors Discovered During Surgical Setup Error Type … Continue reading

Share
Posted in Excel Tips & Tricks, Graphs | Leave a comment

Optimal Colors for Graphs

Did you ever think that someone could make an entire career researching, thinking, writing and advising groups about color? Maureen Stone of StoneSoup Consulting has done just that – and has done it quite brilliantly. Maureen is an expert in … Continue reading

Share
Posted in Excel Tips & Tricks, Using Color | 12 Comments

Formatting Max and Min Values on a Line Graph

I discourage labeling every value on a set of time-series data that will be displayed in a line graph – it just crowds the graph and distracts viewers from the simple message about how something has changed over time. But, … Continue reading

Share
Posted in Excel Tips & Tricks, Graphs | 2 Comments

Labeling Data In Graphs

Looking back and forth from the data being reported to a data legend makes it difficult to easily identify the data in your charts. A simple fix for this is: Point your cursor at the end of the data series … Continue reading

Share
Posted in Excel Tips & Tricks | 1 Comment

Aligning Labels with Tick Marks

Labels should be aligned appropriately with the data being displayed. Don’t align labels between the tick marks when you are showing data at specific time points as it can be confusing to your viewers what date is aligned with a … Continue reading

Share
Posted in Excel Tips & Tricks | 1 Comment

Formatting Comparison Data

How do I change comparison data from a horizontal bar on a cluster chart to a simpler display that displays the comparison data with a simple marker? Before: Steps: Select the data series you want to change. In this example … Continue reading

Share
Posted in Excel Tips & Tricks | Leave a comment