Non-zero cells returning zero

H

hhravn

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
 
H

hhravn

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 :blush:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top