OTHER SERIES

<< Click to Display Table of Contents >>

Navigation:  Series and Segment Format >

OTHER SERIES

Previous pageReturn to chapter overviewNext page

An "other" series designates data from combined sources (e.g. companies representing <2% of product line sales). Data is most often included in this series because it does not provide meaningful information if it were broken down by individual source. By identifying the "other" grouping, Mekko Graphics will automatically default to placing the "other" segment(s) at the top of each bar, no matter how it is sorted. You can also set Mekko Graphics to place your other series at the bottom by checking the box labeled Display Other Series First. This will not affect your spreadsheet.

APPLIES TO: MARIMEKKO, BAR-MEKKO, STACKED BAR, CLUSTER BAR, 100% STACKED BAR, WATERFALL CHARTS

1.Click on the Bars and Series Task Pane

2.Create a new Other series or set an existing series to be an Other Series

3.Select which segments you wish to include in the Other series. You may view the segments by Bars or Series.  You may also choose a value, where all segments below the value will automatically be placed in the Other Series.  To do this, enter a value in the field labeled Include in Other Series Segmented Values < ___.