Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 79
  • Last Modified:

Additional capability add to a Radar Chart

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
Bright01
Asked:
Bright01
  • 2
1 Solution
 
Rgonzo1971Commented:
0
 
Bright01Author Commented:
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
 
Rgonzo1971Commented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now