ENTERING ZERO VALUES

<< Click to Display Table of Contents >>

Navigation:  Chart Creation >

ENTERING ZERO VALUES

Previous pageReturn to chapter overviewNext page

Certain charts have specific rules for how values of zero are displayed in the chart.

In Mekko and Bar charts, if a series is displayed as a bar and a segment in that series has a value of zero or is blank, the segment is not drawn in that chart and the label for that segment is ignored (will not exist in the Label Manager).

For Cluster Bar charts, if a bar has zero height due to the sum of the bar segments equaling zero, the bar is displayed at a net height of zero and both the bar labels and totals are displayed. If all segments are zero, the bar label is displayed, but no segment or total labels are displayed. They also are not displayed in the Label Manager.

For a bar of zero width (Marimekko or Bar-Mekko), segment labels are not displayed and bar labels and bar totals reside in the Label Manager as Unplaced.

For Line or Bar Line charts, if a segment value (point) is blank, Mekko Graphics will not draw a line through that point.  If the segment value is zero, Mekko Graphics draws a line through the zero point value.

For Area charts, if a segment value is blank or zero, it is treated as zero value.

For Pie Charts, if a segment value is blank or zero, the segment is not drawn and the segment label is ignored (will not exist in the Label Manager).