Bob,
Thanks for the response. I was out of the Office all day today but saw
you msg and will test it in next couple of days. Sounds like it should
work.

Brian Reilly, PPT MVP

On Thu, 6 Dec 2007 10:53:46 -0000, "Bob Phillips"
wrote:

Brian,

What you have to do is create a table with a couple of extra ranges. Let's
say that the labels are in A2:A10, amounts in B2:B10 and you want to
highlight on a condition

C2: =IF(condition_met,0,NA())
D2: =IF(condition_not_met,0,NA())

Then select the whole range and chart it. This will create a chart with 3
series.

Find the series 2 series and right-click it and select Chart Type and change
it to line.

Then Double click the data series and change check the Category Name on the
DataLabels tab.

Then right-click the data labels and on the Alignment tab, change the Label
Position to below. Yu can also set the font here.

Repeat for series 3.

You might want to remove the colour from the series 2 and 3 lines as well.