DATA COLUMNS

<< Click to Display Table of Contents >>

Navigation:  Bar Level Formatting >

DATA COLUMNS

Previous pageReturn to chapter overviewNext page

Mekko Graphics allows you to display bars as a standard data column or as a CAGR column.

APPLIES TO: ALL BAR CHARTS EXCEPT PIE CHART

 

NOTE: HORIZONTAL CHARTS DISPLAY THIS FUNCTION IN FORMAT > SERIES DIALOG BOX AND DO NOT HAVE A CAGR OPTION.

TO DISPLAY YOUR BARS AS A DATA COLUMN OR CAGR

1.Click on the Bars/Series button in the Edit Chart Toolbar

2.Click on the Bars and Series Task Pane

3.You have three checkboxes for each bar. Choose the appropriate options in accordance with how you would like your data to appear. You may choose to display data as both in the chart and as a data column if desired.

a.Chart - the default setting is to display all bars in your chart.

b.Data - displays your bar as a column to the right of your chart.

c.CAGR - displays your bar as a CAGR to the right of your chart.

 

You may also designate a bar as a data column or CAGR in the datasheet. Simply right click on the desired bar column header and from the Show Bar drop down menu in the floating toolbar, select Bar as Data Column or Bar as CAGR column. You can display an autototal of the data column or CAGR by checking the Autototal checkbox in the Visibility tab of the Format Bars Task Pane.