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…
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…
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…
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…
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…
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…
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…
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…
How to Make Sparklines in Excel 2007
A sparkline is a very small line chart that is typically drawn without axes or coordinates. It presents the general shape of the variation (typically over time) in some measurement…
How to Make a Dot Plot
A Dot Plot is a graphing utility showing the frequency of different pieces of data in a set. It is extremely effective for showing categorical data. Dot plots can be…