Point and Figure Chart

See if this point and figure example helps
http://andypope.info/ngs/ng8.htm

We are pretty good at Excel programming, so I expect we will be able to help you build the chart. However, we are not always (often?) knowledgeable in the broader field that is involved (in this case, point and figure charts appear to be a financial/stock/investing type of chart). How much of your question is specific to Excel (I know how to build a P&F chart, but not how to do it in Excel) and how much is more investment (I don't know how to build a P&F chart at all)?

As one who know nothing about P&F charts (or investment strategizing in general), I started with Andy's example, then went looking for help understanding what a P&F chart is.
Stockcharts: https://school.stockcharts.com/doku....rts:pnf_basics
Investopedia: https://www.investopedia.com/terms/p...igurechart.asp
Are these adequate descriptions of what a P&F chart is and how you want to approach it?

As Andy's example shows, in Excel, these are just stacked column or scatter charts. If your question is mostly an Excel question, then it should be a simple matter of arranging the appropriate values (calculated from your column of values by date) into appropriate "horizontal x axis values" and "Y axis values" columns and creating and formatting the chart.

Your sample file only includes the daily stock values with no explanation or attempts to calculate the values associated with the "up and down" movements that characterize the P&F chart. If you can help us understand how you intend to calculate the values that go into the P&F chart from your raw data, we should be able to help you program that into Excel. From the Investopedia article, the overall process looks like it should be:
1) Choose "box size" and "reversal amount" parameters that you are using to analyze the data.
2) "Signal process" the raw the data looking for movements that meet your box size and reversal amount criteria.
3) Extract those values from the "signal process" data and place into the data series for the chart
4) Build the chart.

Am I understanding the concept so far? What parts am I misunderstanding? Which parts do you need help with?

At this point, it seems like it is just a simple matter of "conditional formatting" of two chart series. One series for the X and one series for the O. I followed a technique like this one https://peltiertech.com/conditional-...-excel-charts/

1) In F1 I enter X, In G1 I enter O
2) In F2, I enter a formula =IF($D2=F$1,$C2,NA()). Copy/paste/fill into G2 and down to the bottom of the data set.
3) Select columns C, and F:G and insert a scatter chart.
4) Format the "X" series to have an X marker and format the O series to have an O marker.
5) Other formatting as desired.

Will that work for you?

Replace the $C2 part of the formula with the value or calculation that you want for the vertical position of the X's and O's. If you want to use the value in column B instead, use $B2. If you want to count the cumulative X's like COUNTIFS($D$2:$D2,F$1,$C$2:$C2,$C2) or whatever value you want to use for the vertical position. It's not clear to me exactly how you want to calculate this, so I cannot make a specific recommendation.