In VBA to Split Data Range into Multiple Chart Series I shared a VBA procedure that split a range into separate series in a chart. In fact, this is fairly easy to do using conditional chart formatting techniques I describe on my web site (see Simple Conditional Charts). The way these techniques work is to use formulas in separate columns to capture values from the main data column when certain conditions are met. [Read more…] about Split Data Range into Multiple Chart Series without VBA
Peltier Technical Services, Inc., Copyright © 2019, All rights reserved.