PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

Waterfall Chart
Box and Whiskers


 

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Subscribe

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Archive for Friday, June 6th, 2008

Category Axis Tricks for Line and Area Charts - 1

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

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 [...]

Create Excel dashboards quickly with Plug-N-Play reports.