GROWTH LINES

<< Click to Display Table of Contents >>

Navigation:  Formatting Your Chart >

GROWTH LINES

Previous pageReturn to chapter overviewNext page

Growth Lines can be used in charts to visualize the difference typically between first to last bar, although it can be between any two bars (or between any two segments for cluster bar charts). The line is drawn from the start bar to the end bar with an arrow pointing in the direction of the growth.  

APPLIES TO: STACKED BAR, LINE, WATERFALL,

To insert a Growth Line, go to the Edit Chart toolbar and from the Growth Line menu item, choose Insert Growth Line.

To format your growth line, right click and choose Format Growth Line. This will bring up the Growth Line Task Pane.  The easiest way to remove a growth line is to simply select it and hit the DEL key.

 

ADJUSTING A GROWTH LINE

Once a growth line is inserted, you can manually adjust the lines by

1.vertically moving the line itself (by clicking and dragging the line), or

2.moving either the start or end points to a different bar (by clicking and dragging the endpoint of the bar).

 

CHANGING DIRECTION

To change the direction of a growth line, simply right click the line and choose Change Direction. This action will change the boundary points of the line by swapping the start and end points of the line (will  draw the arrow on the opposite side of the line). It will also adjust the label value to accommodate the change in line direction.

 

CALCULATION

To format your growth line calculation, choose Format Growth Line from the Growth Line button in the Edit Chart Toolbar.

You have the option of displaying the growth line as an absolute calculation or as a CAGR by clicking the appropriate radio button. If you calculate as a CAGR, you can interpret the bars as years by checking the checkbox Use Bars as Years in the Format Chart Task Pane.