Have you looked at the "stock" type of chart. Takes three series, giving high,
low and close for the bars. It also seems happy with just two series - omitting
the close figures.

This looks appropriate, you just need to put the required values into the data
series.

No no. This is not the usual high, low, close bar  used in stock and
future charts. That's the point. This type of bar is constructed
differently. There is no "time" dimension.

True, but I think Dave has still pointed you in the right
direction.

To get a bar  chart, you need at least hi/lo/close (if you
want to use an Excel chart) -- so just set close to the HI
or LO.

And there is certainly a horizontal axis to your chart.. it
does not measure time, it measures bars. Your subroutine
will need to do the math to figure out when a new bar is
called for. Nonetheless, it would still be bar 1, bar 2,
etc in the data  series.

As far as I could see, you can omit the "close" series completely. It appears
to work fine with just hi/lo.

> As far as I could see, you can omit the "close" series completely.
It appears to work fine with just hi/lo.
---------------------------------------
I probably was not clear enough in my question. I am not looking for
direction on how to plot the parameter; rather, I was asking if anyone
had already developed the Excel VBA code for determining if a new bar
is needed, predicated on the constant  range selected.