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

M

Microlong

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create blank/empty cell - don't want a zero to be plotted in chart 6
VLOOKUP worksheet function returns zero for empty cells 3
How does a function provide a blank cell as a result 2
excel 2003 zero as last decimal 5
Ignoring empty cells 6
Excel - Geomean - Ignoring Empty Cells 13
can IF leave a cell EMPTY ?? 6
Cell with zero to appear as empty 5

Top