How to deal with blank cells for Pivot Chart

05-03-2005, 09:08 AM

DKDiveDude DKDiveDude is offline

Registered User

Join Date: 11 Dec 2003

Posts: 1

DKDiveDude is an unknown quantity at this point

How to deal with blank cells for Pivot Chart

I have blank cells in my Excel 2003 pivot chart data table. When I switch from displaying one variable to another on the chart, Excel automatically defaults to COUNT the cells instead showing the SUM of the cells. How can one correct for this, other than putting a zero in each blank cell in the data table? Is there perhaps some non-numeric value that can correct for this?

Bookmarks

New topics in Excel Charting

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are Off

Forum Jump

All times are GMT -4. The time now is 09:53 PM.