FORMATTING NUMBERS IN YOUR CHART

<< Click to Display Table of Contents >>

Navigation:  Formatting Your Chart >

FORMATTING NUMBERS IN YOUR CHART

Previous pageReturn to chapter overviewNext page

Mekko Graphics offers tremendous flexibility in creating a number formats for all the different label types in your chart.  Mekko Graphics provides one place where you can set the format for all your labels.

APPLIES TO: ALL CHARTS

 

TO SET NUMBER FORMAT

1.Click the Chart icon in the Edit Chart Toolbar, or right click in the chart area to access the Format Chart Task Pane

2.In the Values tab of the Format Chart Task Pane, you can set numerous formatting options, including displaying your values as a number or percent, thousand and decimal separator, number of decimal places, negative number format, and the ability to display your series name and value on separate lines.

SETTING NUMBER FORMAT PER LABEL GROUPclip0076

Mekko Graphics allows you to set number format per label group. Simply select any label in the group you wish to format, click the Number Format for Label Group dropdown  in the floater menu.  Format the label and that format will be applied to all labels of that group. For example, formatting a bar total label using this tool will automatically format all bar totals in your chart.  You can also do this for segment labels, bar total labels, data row/column labels, axis labels, bar labels,

 

DATA SCALE

Mekko Graphics allows you to alter the exponent value of data in the chart without altering the data itself. This is useful if the values in your data is in, say seven-digit values, but you want to display your data in units of millions. Simply change your data scale to six. You can access the data scale in the Format Chart Task Pane, Values tab, or in right click mini-toolbar.

clip0041

100% CALCULATION

You can choose to calculate your bar total percentage based on a selected series (row).  For example, use this if you’d like segment percentages to be based on a target number instead of the bar total. You can designate a 100% calculation row either in the datasheet or in the Format Chart Task Pane, Values tab or in right click mini-toolbar

clip0042

 

CALCULATED PERCENTAGE

Generally, bar total percentages are calculated from the absolute values, assuming the sum of each bar=100%. The sum of bar total percentages make up the grand total. However, you can calculate it using the value in the selected series as 100% of that bar.  Checking this box will use the entire selected row as reference to set the 100% value of every bar.  

 

BAR WIDTH

For Marimekko and Bar Mekko Charts, you can use the Bar Width checkbox to define a series to set as the bar width for the chart. You can designate the width of the bar, either in the datasheet or in the Format Chart Task Pane, Values tab or in right click mini-toolbar.

If you wish to change the default number format for all charts, you can do this through the Settings tab in the Preference Manager.