Results 1 to 2 of 2

Using a drop down list to filter graph

Threaded View

  1. #1
    Registered User
    Join Date
    10-28-2011
    Location
    uk
    MS-Off Ver
    Excel 2003
    Posts
    24

    Using a drop down list to filter graph

    Good morning.
    I have a Scatter graph with 80+ columns of data. Which is too much. What I am wanting to do is filter the graph by a drop down list.

    So for example the 3 columns should be under a graph called "A" the next 5 under a graph called "B" etc etc.

    The number of columns that need to be shown on each graph varies and is not necessarily 1 after another.
    I think the best thing is a vlookup or drop down list. But I don't even know where to start.
    Please see attached spreadsheet.
    Any question let me know and I will try to clarify.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Graph based on 2 drop down list
    By pphg in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-21-2013, 02:50 AM
  2. [SOLVED] Filter using drop down list
    By DawsonG in forum Excel General
    Replies: 8
    Last Post: 03-26-2013, 11:20 AM
  3. Drop Down/Selection List to Populate a Graph
    By Swoootie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2012, 05:42 AM
  4. filter with drop down list
    By berti in forum Excel General
    Replies: 1
    Last Post: 07-30-2007, 04:43 AM
  5. [SOLVED] I would like to know how to automate graph using drop down list
    By Lokesh in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-17-2005, 12:05 PM

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