+ Reply to Thread
Results 1 to 1 of 1

Charting and Selecting Chart Series based on several drop down criteria

  1. #1
    Registered User
    Join Date
    Oregon, USA
    MS-Off Ver

    Question Charting and Selecting Chart Series based on several drop down criteria

    Situation; we record several enviromental parameters (P) at multiple locations (L) on different dates (D) about every 2 weeks.


    Dates = D1, D2, D3...Dn (about 100 so far)
    Locations = L1, L2, L3 ...Ln (about 80 in total)
    Parameters = P1, P2, P3, ...Pn (about 25 in total)

    The data comes in csv format and I have automated the import procedure into excel and store the data in worksheets by Parameter. That all functions great and have vba code to make that happen in 1 click.

    So I have sheets named P1, P2, P3...Pn. Each sheet contains all the locations L1, L2, L3..Ln in columns (B to Z) and the dates D1, D2, D3,..Dn in rows (4 onwards, with each new data set stored in the next blank row). Each parameter is stored by the associated Date and Location.

    Id like to be able to create x, y Charts on a separate Sheet (Charts) based on dropdowns lists of available dates (e.g. D6 to D12 representing a range from the overall available dates), a location (e.g. L5), and a parameter (e.g. P4).

    Dates will always be X Series and Parameter values the Y Series.

    Any tricks ideas to make this possible.

    Thank you for any suggestions.
    Last edited by ShanghaiNoodler; 09-16-2019 at 02:21 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 02-04-2013, 05:48 PM
  2. Charting: Add Series based on If Statement
    By alexbell2 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-26-2012, 08:17 AM
  3. Selecting a limited number of series in a chart
    By Davidexcel in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-03-2012, 08:35 PM
  4. Charting time series based on different scenarios
    By _keith in forum Excel General
    Replies: 7
    Last Post: 01-08-2011, 06:41 AM
  5. Excel 2007 : Selecting Chart Series Values in Xl2007
    By Jbentley in forum Excel General
    Replies: 2
    Last Post: 07-05-2009, 01:08 AM
  6. Selecting part of a series for a chart?
    By Al in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-16-2006, 07:50 AM

Tags for this Thread


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