Stock chart accesing data from formula

[Filip88]

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