Reflect 0 value in bar chart

**soglejr** · 04-09-2010, 02:08 PM

I have created a duel color bar chart that draws data from an accompanying spreadsheet. The bars are based on formulas and in some cases the answer will be 0.

In those instances I still need a bar (gray) to fill the void.

Is there a programatic way or anyway at all to accomplish this task?

I'm an Access guy and my Excel skills aren't quite this advanced.

Chart is attached.

Thanks for the assist.

**teylyn** · 04-09-2010, 07:43 PM

Hello soglejr,

welcome to the forum.

In your source data, create a new colum and enter a formula along the lines of

=IF(SUM(C20:D20)=0,1,0)

so when both data values for the red and green series are zero, return a value of 1.

Then include that series into the stacked column chart.

see attached.

Is that something that could work for you?

**soglejr** · 04-12-2010, 09:03 AM

I'm stupid. I gave you the wrong example. The gray bar is not based on a calculation. It is based on three values all being zero. In the example you returned to me that would be all three values in the 35D row being zero.

Sorry for the confusion. Thanks for the assist.

**teylyn** · 04-12-2010, 05:43 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save