View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default how can I show 0 values in a pivot chart?

Hi Liz,

Turn on the Show items with no data option. What version of Excel are you
using?

--
Cheers,
Shane Devenshire


"LizPM" wrote:

I want to see 0 values on my pivot table, ie:
10
8
6 x
4 x
2 x
Jan Feb Mar June

6 4 0 2
But March lable disappears, I get:

10
8
6 x
4 x
2 x
Jan Feb June

6 4 2

Can anyone help?