Stacked Bars problem with zero as a date input

[RJL3313]

Hello,

I am trying to create a stacked Bar Chart from my data but some of the entries are zero. I can remove the number zero from the chart but the color of the last zero shows up on top of every bar. I have attached for your review. Notice how the top of every bar is the last row's color.

[MrShorty]

2 possible suggestions:

1) Many charting experts recommend against using 3D charts. The "look" fancy, but they are difficult to read and interpret. http://peltiertech.com/the-perils-of-being-in-3d/ 2D charts show the data in ways that are cleaner and easier to interpret. A 2D chart will not show the 0 values that you have, because the 2D perspective "hides" them from us, where the 3D perspective makes them apparent.

2) You might review this article about plotting blanks, zeros, and empty cells: http://peltiertech.com/mind-the-gap-...g-empty-cells/ You might try using the NA() function/error value instead of 0 for the "blank" values.

[RJL3313]

Thank you very much. Very helpful article. Will take a shot at it.

Thanks Again!!!

RJL3313