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.
Bookmarks