I have a chart where half the users want a black backgroud and half want a gray background. Is there a way I can change the chart colors based on a textbox value? I would have the user choose a value (say, "Dark Background or Light Background") and then, upon commencing the macro it changes the chart. Is this possible? What is the best way to approach this and is there a place I can learn how to do this?
Thanks,
Guy
Re: Change Colors In Chart Based On Textbox Value
Why not use a Data Validation List and then use the Sheet Change Event to change the embedded chart background color? E.g
Re: Change Charts Backround Color Via Drop-Down
You'll have to play around to get the right index number for the gray color (I'm using 2007 and can't determine the correct number), but this should work:
You didn't specify which background (chart area or plot area)
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then
Select Case Target(1, 1).Value
Case "Dark" 'black
Sheet1.ChartObjects("Chart 1").Chart.ChartArea.Interior.ColorIndex = 1
Case "Light" 'another color
Sheet1.ChartObjects("Chart 1").Chart.ChartArea.Interior.ColorIndex = 35
End Select
Else
Exit Sub
End If
End SubRe: Change Charts Backround Color Via Drop-Down
Thank you. That seems to do the trick for the background. Is there a place where I can find all the chart properties (ie Chart.ChartArea.Interior) so I can change exterior, lines, fonts and so on.
Regards,
GG
Don’t have an account yet? Register yourself now and be a part of our community!