Formula Results not Going to a Chart

If the cell contains text, no formatting will change that.

I converted the non-numeric data to numbers using a formula.

what is the formula?
Can you share some sample data with us, please. Show us what you have, what you have tried, and what youexpect.

The formula is =+IF(AND(B4=$N$3),"1",IF(AND(B4=$N$4),"2.5","4")) Cell N3 is "Y", cell N4 is "Q", and cell N5 is "N".

The formula is providing the correct numbers in the cells. For the three cell being evaluated (B4 through B6 currently), they are all "Q", and the result is 2.5 in each of the cells with the formula. The cells with the formula are part of the data series for a line chart to graph the data. However, the chart is registering the data as "0" instead of the 2.5 that is the output for each formula.

I would expect the 2.5 output to be reflected in the chart. I should have a line with three data points, all at 2.5. Instead, I am getting a line with three data points at 0 for this data series.

When I simply type "2.5" in cells and use that as a data series, it works properly. I am trying to automate some of this data entry as there are hundreds of data points each month.

I cannot provide the original workbook, as it is on a government stand alone system with sensitive data.

I appreciate any insights you can provide.

if values are in " " they are text "2.5" is text 2.5 is a number
you could confirm this by typing in a cell isnumber(your cell containing formula) and it will return false
istext will return true

the + after the = is also not needed

lose the " " and see if it works, failing that attach a sample as per the instructions in the yellow banner. the key word is sample, you can create another workbook that displays the same behaviour by using the same formulas and making up the data, as long as it is the same data type. We have no context to the data or even column headings to have a clue what it means