+ Reply to Thread
Results 1 to 2 of 2

Mixing dynamic excel drop down list variables in line chart

  1. #1
    Registered User
    Join Date
    10-14-2020
    Location
    Dar es Salaam, Tanzania
    MS-Off Ver
    Microsoft 2016
    Posts
    1

    Mixing dynamic excel drop down list variables in line chart

    Hi DiliPandey,

    I am new to this forum and not good in mixing dynamic excel drop down list variables and in line chart.

    I need your assistance and elaborated of how to make or create an excel chart with multiple drop down variables, so that they allow a variables to be selected in order for their data values to be displayed using line chart, when I chose one first variable.

    I have attached a summary of the sampled data for the your elaboration, where I want when I select the "Station" a line chart will be shown using the attached values and the Legend will use the the "Sub_station" catories.

    Regards,

    Hezron

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,531

    Re: Mixing dynamic excel drop down list variables in line chart

    Hello ehhezron and Welcome to Excel Forum.
    The pivot chart, based on the pivot table, may be filtered for station (top left corner of chart) and displays the substations in the legend (bottom).
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Dynamic Chart Adding New Variables to Line Plot
    By covanpatten2 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-22-2017, 10:12 AM
  2. Using Drop Down Boxes to Create Dynamic Line Chart
    By Branbran10 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-25-2015, 04:30 PM
  3. Mixing Stacked Bar chart and Line Chart
    By L_McC in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-10-2014, 08:39 AM
  4. Dynamic Chart: Trying to link chart to drop down list
    By mat83400 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-19-2013, 09:20 AM
  5. Dynamic Range Column Chart w/ Dynamic Avg Line (Excel 2007)
    By BrokenBiker in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-04-2012, 11:40 AM
  6. Dynamic chart with Drop Down List
    By Climaxgp in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-16-2012, 01:17 PM
  7. Dynamic Chart with drop down list
    By finlain in forum Excel Charting & Pivots
    Replies: 21
    Last Post: 10-31-2011, 07:40 AM

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