How do I hide a chart (with VBA?)

[Jed Shields]

Hi guys,

I have a dashboard with 6 charts, one for each portfolio manager of a particular branch. Some branches have the maximum 6 PMs, some only have 1. I select the branch using a dropdown list and the charts update for the relevant PMs. In the branches where I have less than 6 PMs, how can I hide the charts that will appear blank?

Cheers,

Jed.

 

[Jed Shields]

Sorted the colours!

ActiveChart.Axes(xlValue).Select
    ActiveChart.Axes(xlValue).TickLabels.Font.Color = RGB(255, 255, 255)
    ActiveChart.Axes(xlCategory).Select
    ActiveChart.Axes(xlCategory).TickLabels.Font.Color = RGB(255, 255, 255)

Thanks for the pointers guys, I got there eventually

 

[cbrf23]

Glad you solved it. Also, try

ChartObjects("chart 1").Visible = False

To delete the charts you could use

ActiveSheet.ChartObjects.Delete

To add charts

Charts.Add

 

[Jed Shields]

Sub HideChart()

ChartObjects("chart 9").Visible = False

End Sub

Lol ... that's a much simpler solution! Just tried it and it works

 

[cbrf23]

Nice. I dont use charts a whole heck of a lot. I knew I had a project where I was hiding/showing charts, so I opened that up when I got to work to find out how I was doing it.