Archive for Thursday, May 22nd, 2008
VBA to Split Data Range into Multiple Chart Series
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
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.
Posted: Thursday, May 22nd, 2008 under VBA.
Comments: 39
