In the example below, the labels for series C are fine, but the labels for series B in the Beta stack and for series A in the Alpha stack have no points to label. The problem is, a stacked column data point with a zero value has height of zero, and the label sits on the boundary between the two points on either side. In the Microsoft newsgroup, someone asked how to hide the data labels in his stacked column chart if the values are zero. With a little knowledge of number formats and a healthy dose of creativity, you can work around apparent shortcomings in Excel’s charting mechanism, neaten up your charts, and produce effects that are otherwise difficult.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |