AVERAGE LINES

<< Click to Display Table of Contents >>

Navigation:  Formatting Your Chart >

AVERAGE LINES

Previous pageReturn to chapter overviewNext page

Mekko Graphics includes the ability to add an Average Line. Average lines display the data average for a given chart, drawing a line across the entire chart at the average value point on the Y axis. By default, average line labels are displayed as a combination of the line value and the line title.

There are two types of average lines: Computed and Manual

Computed Average Lines automatically calculate and display the data average for a given chart, drawing a line across the entire chart at the calculated average value point on the Y axis. Note: For 2Y chart types, you have the option of displaying the average line on the Y or 2Y axis. Computed Average lines will automatically recalculate and adjust your average line if your data changes. There can only be one computed line per chart.

Manual Average Lines can be inserted at any point on the Y or 2Y axis.

COMPUTED AVERAGE LINES APPLY TO: STACKED BAR, CLUSTER BAR, LINE, BAR MEKKO CHARTS

MANUAL AVERAGE LINES APPLY TO: ALL CHARTS EXCEPT PIE AND GANTT CHARTS

 

TO ADD AN AVERAGE LINE

Choose Insert Average Line from Average Line dropdown menu in the Edit Chart Toolbar. You may also right-click in the chart area and from the Format Chart Context Menu, select Insert Average Line.

       

If the chart supports computed average lines, the line will insert at the computed average point for the data in the chart. Subsequent insertions will appear as manual lines halfway between the highest line value and the maximum value of the data on the chart. If there are no computed lines on the chart, the line will always be inserted as a computed line.

For charts that do not support computed average lines, average lines insert at the Y (or 2Y) axis midpoint. Subsequent insertions will place the line halfway between the highest line value and the maximum value of the data on the chart.

You may also right-click the Y or 2Y axis to insert an average line.  Any time you insert an average line from the axis, it is manual and will be placed at the point of insertion

 

TO REMOVE AN AVERAGE LINE

To remove any average line, simply right-click on the line and select Remove Average Line. You may also click on the Average Line and simply press the DEL key

 

MODIFYING THE POSITION OF AN AVERAGE LINE

To move an average line, simply click on the line and drag to your desired position on your chart. If the line is computed, moving it will change it to a manual line. Moving the line will automatically calculate the new value according to the new position.

 

FORMATTING AN AVERAGE LINE

Right click the average line and choose Format Average Line. This brings up the Format Average Line Task Pane.