Chart - Highlighting

**yawnzzzz** · 02-10-2010, 11:39 AM

Hi,

I'm creating an Excel chart, and I have some data that goes from 0-100. I want to show all of the data, but I'd like to have a different format when it goes above 90. What's the best way to accomplish this?

Thanks.

**6StringJazzer** · 02-10-2010, 12:59 PM

In my opinion the best way is to format your data to add two sets of data based on the original set: one set with 0-100, and one set higher. Then plot it as two lines. Visually it might give you what you want.

You could also do this with VBA, modifying formats of individual points, but that would require more effort and VBA knowledge. I wish I had time to do that for you.

Another option is to plot a horizontal line at y=100, to make it easy to see which points are above that.

It would also help if you attached your workbook, and I could illustrate what I mean.

**yawnzzzz** · 02-10-2010, 03:56 PM

I'm pretty good in VBA. Hadn't really crossed my mind to do that, since it's not something that I'll repeat, but I'm sure I could write it in a way that's reuseable. Thanks.

**6StringJazzer** · 02-10-2010, 07:14 PM

Originally Posted by yawnzzzz

I'm pretty good in VBA. Hadn't really crossed my mind to do that, since it's not something that I'll repeat, but I'm sure I could write it in a way that's reuseable. Thanks.

If it's a one-time thing, how many data points? Too many to format individual points manually?