Thread: Excel Stacked Bar Chart Help

Have a look at this link, it may help you

http://peltiertech.com/Excel/Charts/...nalChart2.html

Originally Posted by bobburg

I have a Excel Stacked Bar Chart that is getting data from a matrix below the chart. On the side of the matrix are the categories making up the labels of the series. On the top of the matrix are labels of the person responsible. All the numbers in the matrix are calculated from a pivot table in another sheet. The values are also showing in each part of each bar.

The problem I am having is the chart is reporting the zero's as well. How to I get the chart to not show values of zero.

Hi,

With the chart selected, go to Tools, Options, Charts and tick the 'Not plotted leave gaps' box, however, that will not prevent the '0' showing in the 'Value' selected label unless you 'blank' the zero values, ( ie, instead of the formula =A1+B1 use =If(A1+B1=0,"",A1+B1) or similar to setup your matrix.

hth
---