?
Solved

Need help with Dynamic Radar Chart

Posted on 2016-11-01
4
Medium Priority
?
59 Views
Last Modified: 2016-11-02
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
0
Comment
Question by:Bright01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 52

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 41869716
0
 

Author Comment

by:Bright01
ID: 41870170
Rgonzo,

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

Author Comment

by:Bright01
ID: 41870172
THANKS RGONZO!  Appreciate the help and assistance.
0
 

Author Closing Comment

by:Bright01
ID: 41870177
Quick and accurate!  Great job.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question