Waterfall Chart
Archive for Thursday, May 22nd, 2008
VBA to Split Data Range into Multiple Chart Series
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
A common problem is to make a chart from a list like this one. You want separate series for each item in one column (e.g., the cities in the first column), but your list is different every time, and you have to spend an hour assigning data to each series in the chart.
Atlanta
4
15
Atlanta
5
18
Boston
6
16
Boston
6
16
Boston
7
12
Boston
11
11
Chicago
10
13
Chicago
13
10
Chicago
15
8
Detroit
10
9
Detroit
15
5
Detroit
13
3
Detroit
14
6
Posted: Thursday, May 22nd, 2008 under Data Techniques, VBA.
Comments: 22
