Button to color a selected bar in a chart

[3nity]

Hi everyone

I'm new user of this awesome forum.

Basically, I got a bar chart, and I want to be able to select 1 individual bar and with a click on a button, that selected bar change to color RED or any other attributes (3D, shadow, etc). Is that possible with VBA ?

Please help me

Thanks so much for your time and precious effort.

J

 

[Caleeco]

Hello 3nity,

VBA has the capability to do (almost) anything you can manually do in Excel. The basic syntax would be as follows:

Sub ChangeDataPoint()


ActiveSheet.ChartObjects("Chart 2").Activate
ActiveChart.SeriesCollection(1).Points(1).Format.Fill.ForeColor.RGB = RGB(255, 0, 0)


End Sub

This changes the first data point on "Chart 2" to the colour red. Without knowing the specifics of what you need doing, i can't really offer much more help.

Hopefully you can adapt it to you needs

Thanks
Caleeco