i have an excel file with customer codes and sales values.
There are 'n' customers (say 5,000), and each customer has sales values for 12 periods (in the example).
I would like to graph each customer's sales in the period in a line chart.
I would like the line chart to update each time i select a customer. for example, if I select customer 123, then that customers sales are graphed. If I select customer 456, then that customer's sales are graphed.
This is is a sample of what I'm trying to do.
If successful, there is a larger project based on the above principles.
Sample file is attached.
If you want to do this project please send back either a simple working example for the project, or provide some background on how you'd solve it.
13 freelancers estão ofertando em média $21 para esse trabalho
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
Good at excel analysis for DATA. I can have the work done within a few hours so as to get the count done correctly. I hope to hear from you soon, It would be nice
A pivot chart is an easy option to solve your needs. I will create 1 page I struction manual (included in the price). I have 14 years experience in Excel.