Archive for 'Chart Axes'
Logarithmic Axis Scales
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
Dr. Nicolas Bissantz wrote in Do time series charts really compare time series? about time series being difficult to compare. The chart he discussed showed the cost of energy for three different heating methods. Says Nicolas, “The lines suggest that the price for heating oil has exploded, while electricity and natural gas have increased moderately.”
[...]
Posted: Tuesday, September 16th, 2008 under Chart Axes, Charting Principles, Data Techniques.
Comments: 7
Choice of Category Axis Order
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
In the Calculating Easter post on John Walkenbach’s new Spreadsheet Page blog, John presented a bar chart showing the occurrences of the dates of Easter between 1900 and 2199. He sorted his dates in decreasing order of occurrence (below left). In Gradients, Fills, and Shadows, Oh My I proposed sorting in date order (below right).
[...]
Posted: Sunday, August 10th, 2008 under Chart Axes, Charting Principles, Data Techniques.
Comments: none
Integer Values on Line Chart Category Axis
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
There has been a lot of discussion here lately about XY and Line charts:
Line Charts vs. XY Charts
Line-XY Combination Charts
Category Axis Tricks for Line and Area Charts - 1
Category Axis Tricks for Line and Area Charts - 2
Order of Points in XY and Line Charts
Many of these posts have described differences between XY and [...]
Posted: Monday, July 28th, 2008 under Chart Axes, Chart Types, Charting Principles, Combination Charts.
Comments: none
Order of Points in XY and Line Charts
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
There has been a lot of discussion here lately about XY and Line charts:
Line Charts vs. XY Charts
Line-XY Combination Charts
Category Axis Tricks for Line and Area Charts - 1
Category Axis Tricks for Line and Area Charts - 2
One interesting thing about a line chart with a date scale X axis is the order of the [...]
Posted: Thursday, July 24th, 2008 under Chart Axes, Chart Types, Charting Principles, Combination Charts, VBA.
Comments: none
Excel Category Axis Types
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
In Line Charts vs. XY Charts I described the difference between these two Excel chart types. There is no difference in the ways you can format the series, so perhaps the names of the chart types are confusing. The differences are in the ways their respective X axes treat the X data. I discussed the [...]
Posted: Monday, July 21st, 2008 under Chart Axes, Charting Principles, Formatting.
Comments: none
Re: Graphical Propaganda
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
In More graphical propaganda, Andrew Gelman of the Statistical Modeling, Causal Inference, and Social Science blog shows some pie charts of recent Kenyan election results which he got from John Sides’ blog post, Election Fraud in Kenya in The Monkey Cage blog. The charts are awful; as Andrew notes, the colors change and the [...]
Posted: Thursday, July 10th, 2008 under Bad Charts, Chart Axes, Chart Types, Charting Principles, Example Charts.
Comments: 1
Line Charts vs. XY Charts
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
In Line-XY Combination Charts I showed how to make a combination Line-XY chart. It is probably important to discuss the differences between line charts and XY charts. The documentation is not clear, and the names of the chart types are not helpful; in fact, they lead to confusion.
The icons in the Chart Type dialog and [...]
Posted: Thursday, July 10th, 2008 under Chart Axes, Chart Types, Charting Principles.
Comments: 3
Line-XY Combination Charts
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
When people think of an Excel combination chart, they usually think of a chart with lines and columns, or something similar that they found on the list of “Built-In Custom” chart types (I just love that oxymoron). However, line and XY series are types that combine to make decent charts. The line chart’s Date Scale [...]
Posted: Thursday, June 26th, 2008 under Chart Axes, Chart Types, Charting Principles, Combination Charts.
Comments: 5
Category Axis Tricks for Line and Area Charts - 2
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
In Category Axis Tricks for Line and Area Charts - 1, we saw how to use two line series to create a two-toned line chart. This is useful if we want to differentiate between actual values up to a certain date and predicted values thereafter, or if we want to distinguish values from different periods [...]
Posted: Sunday, June 8th, 2008 under Chart Axes, Charting Principles, Data Techniques.
Comments: none
Category Axis Tricks for Line and Area Charts - 1
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
Let’s look at the behavior of line charts and the category axis. Here is some simple data I made up just for this exercise, and a typical line chart plotting the data.
Value
1
11
2
7
3
12
4
7
5
15
6
13
7
16
8
12
9
17
10
16
11
18
Okay, not too boring. Let’s see what happens if we split the data into two series, red and blue. The red series will include [...]
Posted: Friday, June 6th, 2008 under Chart Axes, Charting Principles, Data Techniques.
Comments: 2





