Chart Formatting and coding

Hi,

If you upload your workbook we may be able help.

You've posted this in the VBA forum, so I am guessing you would prefer a VBA solution over the spreadsheet solution I would use for this. However, with an hour gone by since your last post, I'm going to suggest it anyway.

I would "highlight" a subset of points by adding a second series to the chart. This second series will be formatted as desired to accent those points however you like.

1) first step is to put the desired formulas into the spreadsheet to create a column for the second series. This formula will
A) count how many times a given furnace has entries >=20. I would use a COUNTIFS() function for this: =COUNTIFS($A$2:$A$1000,A2,$D$2:$D$1000,">=20"). Maybe in column E.
B) A simple =IF() function to make a copy of column D if column E is 4 or more. =IF(E2>=4,D2,NA()) Maybe in column F.
2) Then, add column F as a second series to the chart and format as desired.

That's how I would do it without VBA. Even if I were doing this with VBA, I would do the same basic thing, only using VBA to perform the countif and put the values in column F.

Hi,

Here's a start. I've added conditional formatting to your table and a couple of helper columns
Column E counts the number of times that >=20 and column F contains the number of counts that >4

Orange identifies those furnaces that have recorded >=20 and the red highlights any where there are more than 4 counts >=20

I've added some test data in rows 6-12 just to test the red formats. You can of course delete those.

I'm just pondering how best to put an indication on the chart

@Mr Shorty

Great minds and all that

I got sidetracked earlier.

...here's an update with the chart showing any relevant Maximum in red. I added another few test rows 13:20 which you may of course remove.