Fixing a Graphic

I have a great little Radar Chart that Teylyn helped build out last year.  When I replicated it, it broke.  I can't seem to trouble shoot the fix.  Attached is the WB.  The Radar Chart works perfectly.  When you change a Y for Yes include to N, no do not include, you will see that the chart adjusts itself.  On the second Radar Chart (2), it doesn't work.  It should be a simple fix for someone who knows what they are doing.   If you take a shot at fixing this, please let me know what you did to change the outcome and make it work.

Much thanks in advance.

B.
Radar-Chart-Fix.xlsm
Bright01Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kanti PrasadCommented:
Hi

use lower cases 'n' or 'y' as it seems to be case-sensitive. If you still have issues, let us know.

The 2nd chart does not seem to be accepting capital N but it is ok with capital Y
Rgonzo1971Commented:
Hi

Go to Select data and replace the Series Values with the named ranges

='Radar_Chart (2)'!condition1
&
='Radar_Chart (2)'!condition2
also change the axis label range with
='Radar_Chart (2)'!legend

Regards
Bright01Author Commented:
Rgonzo,

Very close!  

I got the second chart to work and did not add = Radar_Chart(2)'Legend.  Not sure how/where to do that.  The third chart requires, I think, another condition statement in the Named Ranges.  Is that right?  And if so, what should it be?
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Rgonzo1971Commented:
for the 3rd chart create another set of worksheet based name ranges

to add the legend go to
Select data under Horizontal (Category) Axis Labels / Edit (Button)
Bright01Author Commented:
Rgonzo,  Thanks for sticking with me on this.  I've been troubleshooting this for an hour and while the first two work, I cannot get the third graphic to work correctly.  I created a Legend3 with SCOPE the name of the Tab/WS.  When I  include it in the Horizontal Axis Label I get a "Formula in the worksheet contains one or more invalid references..." error.  However, it will accept one of the other Legend entries (either Legend 1 or 2).  When I go back to the Names, Legend 3 is identical except for the reference to col. K instead of J.  As you may recall, there is an extra line of data (3 in total) in WS Radar_Chart(3).

Any ideas?

Thank you again,

B.
Rgonzo1971Commented:
please send another dummy as the first one had only 2 charts
Bright01Author Commented:
Here you go.

Question, if I change the name of the Tab (WS) will it automatically update the Range name reference to the WS?

B.
Radar-Chart-with-3-Variables.xlsm
Rgonzo1971Commented:
Yes

and if you use numbers as description the formula you use to choose the lines have to change
Radar-Chart-with-3-Variables.xlsm
Bright01Author Commented:
Rgonzo,

It works to a point.  Please try this.  In E6 through E11, begin adding a "description" (e.g. Test1, Test2, Test3....).  BUT, stop at Test 5 (cell E10).  Look at the Graphic.  Works perfectly.  Then put in Test6 in cell E11. The model breaks for some unknown reason concerning a formula or cell reference.

Thank you!

B.
Rgonzo1971Commented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bright01Author Commented:
Like a "charm"!  Thank you very much.  Appreciate the help.  Can you tell me where I went wrong in troubleshooting that last problem?  How did you fix it?

Thanks again.

B.
Rgonzo1971Commented:
because the file had numbers as Description I had to change the formula, at the last version it is once more text so the old  formula goes back ( it was on the wrong column in your example although
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.