ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Non-zero cells returning zero (https://www.excelbanter.com/excel-programming/400572-non-zero-cells-returning-zero.html)

[email protected]

Non-zero cells returning zero
 
For some reason i cannot chart the data from this excel sheet. I have
a function retrieving data from the web, and returning it to the
cells, and the values display correctly, but when i try to chart it,
the value of every cell is displayed as zero. Any ideas as to what the
problem could be?

http://hhravn.dk/cc.xlsm


[email protected]

Non-zero cells returning zero
 
On 5 Nov., 09:45, wrote:
For some reason i cannot chart the data from this excel sheet. I have
a function retrieving data from the web, and returning it to the
cells, and the values display correctly, but when i try to chart it,
the value of every cell is displayed as zero. Any ideas as to what the
problem could be?

http://hhravn.dk/cc.xlsm


Ok, i've got it.. The function returned a string.. Changing it to int
solved the problem. I'm new at excel :o)



All times are GMT +1. The time now is 12:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com