View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
bj
 
Posts: n/a
Default 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?