Editing Charts & Graphs

If you can click it, you can edit it!

Note: If you are a novice user of Excel and would like to see more information about charts and graphs, click here – Anatomy of a Chart.

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

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

Variation and Its Discontents

Funnel Plots for Fair Comparisons by Stephen Few and Katherine Rowell Central to quantitative data analysis is an understanding of variation. When we measure multiple occurrences of things to determine how and to what extent they differ, we’re examining variation. … Continue reading

Share
Posted in Communicating Data to the Public, Data Analysis, Design Basics, Editing Charts & Graphs, Graphs | 1 Comment

Give Your Y Axis a Break

I recently got to glimpse what a jet-setter’s life might be like when I went to Niagara Falls, Canada, for less than a day (in and out in about eight hours) to deliver a keynote address to a very nice … Continue reading

Share
Posted in Editing Charts & Graphs, Graphs, Newsletters | Leave a comment

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

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

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

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

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

Share
Posted in Editing Charts & Graphs, Excel Tips & Tricks | 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

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

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 used for any situation for which a bar chart is … Continue reading

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

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

Editing the Data

Data for example: The values in a chart are linked to the worksheet data from which the chart is created. To make changes to the data plotted in the existing chart: Go to the worksheet that contains the data that … Continue reading

Share
Posted in Editing Charts & Graphs | Leave a comment