BAR COMPARISON LINES

<< Click to Display Table of Contents >>

Navigation:  Formatting Your Chart >

BAR COMPARISON LINES

Previous pageReturn to chapter overviewNext page

Bar Comparison lines can be used in charts to visualize the difference between pairs of bars or segments. The difference is automatically calculated and updated whenever the underlying data changes. 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, CLUSTER BAR, LINE, BAR MEKKO, WATERFALL

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

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

 

ADJUSTING A BAR COMPARISON LINE

Once a bar comparison 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 bar comparison 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.