Solved

Additional capability add to a Radar Chart

Posted on 2016-11-02
3
18 Views
Last Modified: 2016-11-02
EE Pros,

Roganzo1971 just enhanced a Radar Chart that Teylyn originally helped me create.  I now need a slight enhancement.  Right now, by selecting a y ("yes") or a n ("no") in the column next to a specific variable, the chart dynamically reconfigures to reflect what has been chosen to display (i.e. those rows with a y next to them).  

I'm trying to now provide the same capability to the data in the columns.

That's it!

Thank you in advance,

B.
Radar-Chart-with-4-VariablesV2.xlsm
0
Comment
Question by:Bright01
  • 2
3 Comments
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
0
 

Author Closing Comment

by:Bright01
Comment Utility
Wow...... How did you do that?  More importantly, can you tell me what I missed in the first fix you did for me?  I'd like to make sure I don't screw it up again.

Much thanks for the great work.

B.
0
 
LVL 48

Expert Comment

by:Rgonzo1971
Comment Utility
with vba to hide the columns
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("F4:I4")) Is Nothing Then
    For Each c In Range("F4:I4")
        If c = "n" Then
            c.Offset(, 7).EntireColumn.Hidden = True
        Else
            c.Offset(, 7).EntireColumn.Hidden = False
        End If
    Next
End If
End Sub

Open in new window


the series must have the range legend3 and the condition corresponding to them
In Select Data  Edit Series Series Values
and Axis Labes  / Axis label Range
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Extracting Text within 2 Symbols in Excel 5 31
VLOOKUP to a Closed Workbook 22 62
Excel 3 20
TT Copy Formula 3 15
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. …
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

771 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

11 Experts available now in Live!

Get 1:1 Help Now