I have a data table with formulas that is a summary of a group of worksheet.
I have a graph using the summary table as the source and one cell is graphing
as "0" even though there is a number is the table. All the others are fine.
Any suggestions for the cause of this issue?
bj - 13 Dec 2005 21:41 GMT
the value is the cell is probably really in a text format
I would suggest using
=value(trim(your equation))
> I have a data table with formulas that is a summary of a group of worksheet.
> I have a graph using the summary table as the source and one cell is graphing
> as "0" even though there is a number is the table. All the others are fine.
> Any suggestions for the cause of this issue?