Skip to content

Latest commit

 

History

History
48 lines (25 loc) · 1.96 KB

column-chart-ordinal-data.md

File metadata and controls

48 lines (25 loc) · 1.96 KB

Charting a column chart using ordinal data

Since you've already covered the basics in Part 1 let's jump right into part two.

1. Get your data ready

Ordinal charts take data in a very similar way to time charts. The only difference is that the top left cell shouldn't be "date." This will let chartbuilder know that your x-axis is supposed to be categories.

2. Paste it into Chartbuilder from your spreadsheet software

This is the data we'll use during this tutorial but if you're confident, try using your own.

When you copy and paste into Chartbuilder the chart should update with a bunch into a single line

ordinal first step

lets change those to columns by clicking the "Columns" button

columns button

3. Change the series to columns

In each series options change the selector from line to column.

your chart should look like this right now.

image of chart

4. Adjust the axes

The left axis ranges from 0 to 0.9 with ticks at 0.225, 0.450, and 0.675. Let's make those values nicer by changing the axis max to 1.0 and the number of ticks to 5.

This data is in billions of dollars so add "$" in the prefix field and " billion" in the suffix field

5. Add a title and source

You did this in Part 1 so head there if you need a refresher.

A title of "Baggage fees collected, 2014" and a source of "US Department of Transportation" should suffice

Your Chartbuilder should now look like this ready for download

6. Download!

Click the Download Image button to save the file.