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

  • Thread starter Thread starter david marcus
  • Start date Start date
D

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
 
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.
 
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/
_______
 
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]
 
Back
Top