Not a difficult project. I would add a dropdown box where the customer number is selected. Using that number as the key the apropriate row is selected to be displayed on the chart. I have actually done it already. It took me 2 minutes. I can send it to you for free if you allocate to me some other project.
MS Excel advanced expert. 30 years experience in MS Excel. VBA programming. Data mining and analysis, stochastic simulation, discrete event simulation, Excel Solver, genetic algorithms, neural networks and other advanced models. I have a high performance desktop computer with which I can deal with extremely large and complex worksheets.