pivot table and pivot chart issue

[nparsons75]

I have a pivot table that is showing #div/0!

I need to chart this data, when I do, instead of no data showing where there is no value I get #N/A.

The data is a column containing dates. 1/1/14 down to 31/12/14 with each day showing on a different row.

For the pivot table I have added another column formatting it as weeks. So in the pivot chart I choose week and average total score.

I have added images to help show.

I need the errors to not show and on the chart to not show any value other than the ones on the bar charts (not zeros)

Is this at all possibe?

[/URL][/IMG]

[/URL][/IMG]

[/URL][/IMG]

 

[Andrew Poulsom]

Can't you apply a Value Filter 'Average of % SCORE is grater than 0'?

 

[nparsons75]

Possibly, just not sure how? would that resolve the issue?

 

[nparsons75]

Think i have resolved it. In pivot table options I have selected "for error values show" and selected nothing, working fine.