ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Graphing errors in excel (https://www.excelbanter.com/charts-charting-excel/60273-re-graphing-errors-excel.html)

bj

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?



All times are GMT +1. The time now is 07:51 AM.

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