vba - Color each label of Excel bar graph differently -
i have horizontal bar graph, color each of labels differently. currently, can set 1 color of them. looking vba code, can me achieve this. can please tell me if possible? if yes, how access each of these labels differently.
do need vba, or need know how in general?
in general, if click once on bar, select whole series of bars. if click again, select individual bar, , can format it. it's not double click, it's 2 single clicks.
but if need vba, go this:
with activechart.seriescollection(1) .points(1).format.fill.forecolor.rgb = vbred .points(2).format.fill.forecolor.rgb = vbblue '' etc. end
Comments
Post a Comment