Hi,

First time poster here -- learning to use Excel as quickly as possible, currently trying to get a hang of VBA, but one question:

I want to make a scatter plot with a new series according to "Customer ID" below:


Transaction ID Customer ID Year Amount
1 1 2006 30000
2 1 2007 30000
3 2 2007 75000
4 3 2008 100000
5 3 2009 140000
6 3 2010 120000
7 4 2008 72500
8 4 2009 80000
9 4 2010 110000
10 5 2009 115000
11 5 2010 100000


The goal is to have a separate line for each unique customer -- I'd really appreciate any tips you have out there! Thanks!