Solved

Need help with Dynamic Radar Chart

Posted on 2016-11-01
4
18 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
  • 3
4 Comments
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
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 demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now