Bright01
asked on
Need help with Dynamic Radar Chart
EE Pros,
Greeings! I have this great Radar/Spider Chart that Teylyn helped me with several years ago. I need some help with it now. I have added another row and cannot get it to work right. In the original Chart, you could select which rows you wanted to include (i.e. Y = "Yes", N = "No"). When selecting, the chart would auto change itself to only include those rows that had a Y next to them (D6-D12). I cannot get it to work right.
Can you take a look?
Much thanks in advance.
B.
APM-Radar-Chart-with-4-Variables.xlsm
Greeings! I have this great Radar/Spider Chart that Teylyn helped me with several years ago. I need some help with it now. I have added another row and cannot get it to work right. In the original Chart, you could select which rows you wanted to include (i.e. Y = "Yes", N = "No"). When selecting, the chart would auto change itself to only include those rows that had a Y next to them (D6-D12). I cannot get it to work right.
Can you take a look?
Much thanks in advance.
B.
APM-Radar-Chart-with-4-Variables.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANKS RGONZO! Appreciate the help and assistance.
ASKER
Quick and accurate! Great job.
ASKER
Thank you very much! Works just like requested. Can you share with me what I was missing? I tried to troubleshooting this graphic for several hours to no avail. You fixed it the first time! I'd like to know if you don't mind, what I missed.
Thanks again. I've added a request for enhancement to the same graphic.
https://www.experts-exchange.com/questions/28980486/Additional-capability-add-to-a-Radar-Chart.html
Appreciate your help.
B.