+ Reply to Thread
Results 1 to 3 of 3

Change chart price data dynamically based on user selection

  1. #1
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    166

    Exclamation Change chart price data dynamically based on user selection

    Good morning community.

    I want to create a chart where i can compare competition price in many item categories. I want that the end user can click on a box to change data on the chart.

    The end user can click on IC1 : Antenna, or IC2: Antenna cable, or....., or, IC12: Drying kit. If the end user clicks on IC1 : Antenna, the following criterias for each competitor must be displayed:

    OM: Antenna type SD, Antenna Type LD
    AB: Universal headpiece
    Medel: DL Coil Base
    Cochlear: Slimline Coil

    When end user clicks on IC1: Antenna, the chart needs to look like as below:

    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Capture.PNG
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    If the end user clicks on IC2 : Antenna cable, the following criterias for each competitor must be displayed:

    OM: Antenna cable 40 mm, Antenna cable 60 mm, Antenna cable 100 mm, Antenna cable 280 mm
    AB: UHP to Naida CI Q70 Cables 90 mm, UHP to Naida CI Q70 Cables 110 mm, UHP to Naida CI Q70 Cables 240 mm, UHP to Naida CI Q70 Cables 300 mm
    Medel: DL-Coil cable for connection of SONNET and DL-Coil 65 mm , DL-Coil cable for connection of SONNET and DL-Coil 90 mm , DL-Coil cable for connection of SONNET and DL-Coil 280 mm
    Cochlear: Slimline coil cable 60 mm, Slimline coil cable 80 mm, Slimline coil cable 110 mm, Slimline coil cable 250 mm

    When end user clicks on IC2: Antenna cable, the chart needs to look like as below:

    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Capture2.PNG
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    And again, and again UNTIL IC12: Drying kit.

    I upload the attached file "CI_Accessory template", and you can find the chart on the sheet "national dashboard 2" and raw data in the sheet "Raw data inputs".
    You can just begin the step with IC1 and IC2, i can finish the end.
    Thank you for your help.
    Attached Files Attached Files

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

    Re: Change chart price data dynamically based on user selection

    I thought that after a few days with no responses, it might be appropriate to offer the following proposal, which doesn't produce output in exactly the manner that was requested.
    On Sheet 1 a pivot table is produced from the data on the Raw data inputs sheet.
    Brands and Name of Item are placed in the Rows area, Price (end user in local curency after VAT) is placed in the Values area (shown as MAX) and Category of Item is placed in the Filter area.
    The pivot chart is also modeled on Sheet 1.
    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.

  3. #3
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    166

    Re: Change chart price data dynamically based on user selection

    Thank you JeteMc, Pivot table is a good alternative. I can't put this thread as solved because I really want to establish a navigation experience for the end user.
    Please find data with pivot table.
    Attached Files Attached Files
    Last edited by Luu4466; 11-16-2020 at 08:52 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. [SOLVED] Expand Defined Name Range Horizontally to Dynamically Change Chart with new data
    By machl22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2017, 12:14 PM
  2. [SOLVED] Can a Chart dynamically change it range based on a cells value?
    By Bobbbo in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-09-2017, 03:11 PM
  3. [SOLVED] VBA code to change a chart based on a selection from a listbox on a form
    By cinstanl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2016, 03:07 PM
  4. Dynamically change data based on parameters
    By MrWicked in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-07-2015, 04:47 AM
  5. Dynamic Pie Chart Based on User Selection
    By mcollins789 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-03-2013, 06:17 PM
  6. Change percentage -> dynamically change price
    By dmb41 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-12-2013, 11:26 AM
  7. Question on ways to hide a chart and cells based on user selection
    By delaneybob in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-01-2012, 06:14 AM

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