• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need to display by customer and date

S

Solly

New Member
Hello, I'm trying to create a graph in excel to show how regularly we deal with a customer. I have a worksheet with the following columns: Date, Customer, order Value


I'm trying to make a graph where I can select one customer (from a drop down list) and it will display the date distribution of their orders (along the bottom) and the order value vertically. I'm sure this is pretty easy but for the life of me I cannot figure it out.


I'm using Excel 2007, Any help is much appreciated!
 
Oh I should add I want this graph on a separate worksheet, not the same one as the source data...
 
Check out Chandoo's post on dynamic charts (in the Dashboard series). Just search the site for dynamic chart. I used that and was up and running in no time!
 
You must log in or register to reply here.
Back
Top