SORTING SERIES

<< Click to Display Table of Contents >>

Navigation:  Series and Segment Format >

SORTING SERIES

Previous pageReturn to chapter overviewNext page

Sorting your chart data clarifies your chart content and message.  Mekko Graphics allows you to sort by bar or series.

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

 

1.Click on Format Chart Task Pane and select the Sort Tab

2.You can choose to display your series in the order in which it appears on your spreadsheet, with the series listed first in your spreadsheet displaying either on the bottom building up, or starting at the top and building down.  Alternatively, you can sort your series as Biggest on Top, Biggest on Bottom, or you can define a custom sort order for your chart.   If you select Custom sort, simply drag and drop each series to the desired sort position.

Once you have identified your sort options, you can choose to exclude one or more series from that sort.  If you wish to identify one or more series to exclude, go to the Format Series Task Pane, Visibility Tab and click the series you wish to exclude. Then choose from the drop menu in the Sort Order column. You can force the series to appear on the top or the bottom, regardless of the sort options chosen in the Format Chart Task Pane.

Negative segments appear in the order they appear in the spreadsheet. You can also choose to reverse the order for negative segments in the chart by checking the Reverse Order for Negative Segments checkbox in the Sort tab of the Format Chart Task Pane.