Add Zero Values to Pivot Chart

K

Karen

Would someone please help me with this one?. I'll copy the link to my
previous question. The last question was never answered and I would be
greatful if somone could help me with this.

Hope the link works - I never attcahed a link before
http://www.microsoft.com/communitie...8d79f3-11d7-4d57-8646-736184fd0ef1&sloc=en-us

The last question was:
Thanks again for your help Shane. The instructions on what you showed me work
great. Although, I want to create a chart from the data. If the errors for
that month are zero, I want the pivot table data and the chart to reflect
that. Is there a way of tweaking the below instructions so that data will be
shown?

Thanks, Karen
 

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

Pivot Chart Dual Category Axis not Preserving Formatting 2
Pivot Table Drop Down Box Disappears in Chart 0
Excel 2007 Chart with Zero Values 5
Excel 2007 charts: want to avoid zero values 1
Pivot Table with Multiple Consolidation ranges 0
Sum values in a range conditional upon dates and an additional fie 7
Excel 2007 Chart Data Selection- Arrow Keys Frustration 0
pivot chart suppress zero value 0

Top