Hello,

I have problem with creating stock chart.

I am accesing data (cells are in number format) having formula, relating to data from different table.

e.g. my stock chart accessing data from cell A1, cell A1 has formula =(B1&C1), lets say cell B1 = 100 but cell C1 is empty, so i want to display in A1 number 100, this number should be displayed on stock chart, the problem is that stock chart does not work, since it considers the cell A1 in wrong format, despite i have format of cell as number.

Is here any way how to display stock chart, using data, taken from formula?

Thank you

Filip

Your example is very limited.
Please give more examples of what can appear in columns B and C. I guess other things than blank - why else concatenate? And don't forget to mention what should appear in column A.

In cells B and C are only numbers (accessed by Vlookup) in format 0,00000 or blank, i concatenate because number will contain only one cell. A1 should display only that one number.

=value(b1&c1)

thank you, it works