# Excel Tips & Tricks

## How to Make a Soda Chart

Here’s an example of a real-world problem. In a deprived inner city borough of the U.K. with the usual range of problems — drugs, gangs, gun and knife crime, alcohol-fueled disorder — we have a multi-agency collaboration to attempt to … Continue reading

## How to Simulate a “Broken axis” Value Axis

This type of chart is often used when a few data points greatly exceed the others. When plotted on a standard chart the other values are dwarfed. The chart actually consists of two charts. Both charts use the same data … Continue reading

## How to Make a Vertical Bullet Chart

Anatomy of a Bullet Chart How to Make a Vertical 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 … Continue reading

Posted in Excel Tips & Tricks, Graphs | 1 Comment

## How to Make a Gantt Chart for Repeated Tasks

A Gantt chart for repeated tasks consists of a bar chart series showing the duration of a task, stacked on a transparent bar that pushes the visible bar out to the start of the task. My technique added two more … Continue reading

## How to Make a Gantt Chart

A Gantt chart is a horizontal bar chart often used in project management applications. The attached Excel workbook shows a Gantt chart set up to depict the schedule for a project in cell range A1: C13. The horizontal axis represents … Continue reading

| 1 Comment

## How to Make a Table Lens

A table lens display provides a way to view potential correlations between several quantitative variables simultaneously. Step 1. Enter the labels for the data set in column A. See attached Excel spreadsheet. Step 2. Enter each set of quantitative values. … Continue reading

## How to Make a Deviation Graph through Time

A graph displays a deviation relationship when it features how one or more sets of quantitative values differ from a reference set of values. The graph does this by directly expressing the differences between two sets of values. (Stephen Few … Continue reading

## How to Make a Deviation Graph

A graph displays a deviation relationship when it features how one or more sets of quantitative values differ from a reference set of values. The graph does this by directly expressing the differences between two sets of values. (Stephen Few … Continue reading