Graphing errors in excel
the value is the cell is probably really in a text format
I would suggest using
=value(trim(your equation))
"Brian" wrote:
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?
|