+ Reply to Thread
Results 1 to 2 of 2

Dynamic Graphs

  1. #1
    Registered User
    Join Date
    09-02-2008
    Location
    Cincinnati
    Posts
    5

    Dynamic Graphs

    I am fairly proficient at using Excel but I am attempting a project that is a bit beyond my abilities. I am attempting to create a spreadsheet that will have a dynamic line graph that changes based on a user selected Combo Box. I have a bunch of different products that are all broken down by categories. I want to have 2 combo boxes, the first one will display all of the categories. After the user selects the category the second combo box will be populated with only products from that category. Then, once the user selects the product from that category the chart will show the sales data for that product. I have attached a sample of what they layout of the data is. There will be many more categories and products and several years of sales data in the actual project though.

    Thanks for your help.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Dynamic Graphs

    Have a read of this article on dependent data validation
    http://www.contextures.com/xlDataVal02.html

    You can then use a SUMPRODUCT formula to determine the row number of the select product and INDEX formula to build a chartable set of data.

    In the attached example you just need to add the data validation technique to the 2 input cells A63:B63. If you change them manually the chart will update.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1