| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can I show 0 values in a pivot chart?
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how can I show 0 values in a pivot chart?
Hi again,
In 2003 - double-click the Month field button and turn the option on, it's at the bottom left of the screen. In 2007 - select the Month field and choose PivotTable Tools, Options, Field Settings, Layout & Print, Show items with no data. -- Thanks, 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In bar chart using values-NOT show the value of zero | Charts and Charting in Excel | |||
| do not show zeros in pivot chart (pie chart) | Charts and Charting in Excel | |||
| can i show repeated values in a pivot table? | Excel Discussion (Misc queries) | |||
| How can I get the zero values at the end of a chart not to show? | Charts and Charting in Excel | |||
| Don´t show zero values in Pivot Table | Excel Discussion (Misc queries) | |||
Linear Mode
