Changing format of a particular point in a series (conditionally/vba)

[david marcus]

I have a single series which is charted each month and want to
automatically format one of the points (a bar) a different colour.

Is it possible to do this automatically?

thanks for any advice

david marcus - note the email address will not work

 

[Poh]

Hi!
Click once on the particular bar where you wish to have
different color, system will select all bars in the chart.
Click once again, the system will select only the bar
that you are clicking on. Call out Format Data Point and
select the desired color or pattern.

 

[Jon Peltier]

One more step. Turn on the macro recorder while you do the formatting,
then insert the appropriate lines into a clause like this:

With ActiveChart.SeriesCollection(i).Points(j)

' format the point here

End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[david marcus]

Thanks, but the problem (which I should have stated more clearly) is that
the order of the point may vary - is it possible to refer to it by its name,
rather than the points(index)??

David marcus

<[email protected]

 

[Jon Peltier]

David -

By "Name" of the point, you mean the category label? The first macro in
this post formats points based on the X label for that point.

http://www.google.com/groups?selm=OItoyvW9BHA.2028@tkmsftngp04

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______