How to make empty cells as zero in excel add-ins for SQL Server an
 

I met a problem when I want to create chart by Excel add-ins for SQL SERVER
Analysis. after I extracted data from some cube, I find some cells are empty.
It will be generated incorrect chart for some cells are ignored. So , how to
make zero for empty cells. or if not, how to make correct chart with some
empty cells in Excel add-ins.
notice: Free-form is used by this case.
thanks.
--
Developer
QA Dashboard
Microsoft China Development Centre