Results 1 to 5 of 5

Creating Dynamic Chart Using Selectable Drop Down Lists

Threaded View

  1. #1
    Registered User
    Join Date
    06-30-2010
    Location
    Tucson, Arizona
    MS-Off Ver
    Excel 2007
    Posts
    58

    Creating Dynamic Chart Using Selectable Drop Down Lists

    Hello,

    I would like to create a chart similar to what excel creates for you when you use the pivot chart wizard. Specifically I would like the drop down menus with clickable boxes to select a piece of data and plot it on a graph.

    I am familiar with creating drop down lists using data validation, but I am stumped on how I create a selectable drop down list.

    Basically I wish I could just add data to the pivot table chart as I want to graph data against pivot table data on the same chart, but I don't think that is possible.

    Thanks in advance!
    Last edited by montego; 08-05-2010 at 11:12 AM.

Thread Information

Users Browsing this Thread

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

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