【正文】 2 PK Shapes Libarry – Charts Bar Hints: 1 Calculate and enter the value corresponding to the area below the column in the row marked Space 2 Enter the height of the column in the row marked Column row 3 Add/remove columns and rows as required 4 Add series lines between the columns manually, if required 5 To change the height of the columns select Chart Options and turn on the yaxis, then use Format Axis/Scale to set the length of the yaxis (check the “Automatic” button). Once the scale is set, use Chart Options again to remove the yaxis 5 543 32 21 . 541 . 51 . 5 1 . 5L a b e l A L a b e l B L a b e l C L a b e l D L a b e l E L a b e l F T o t a lWaterfall chart 3 PK Shapes Libarry – Charts Bar Hints: 1 Calculate and enter the value corresponding to the area below the column in the row marked Space 2 Enter the height of the column in the row marked Column row 3 Add/remove columns and rows as required 4 Add series lines between the columns manually, if required 5 To change the height of the columns select Chart Options and turn on the yaxis, then use Format Axis/Scale to set the length of the yaxis (check the “Automatic” button). Once the scale is set, use Chart Options again to remove the yaxis 112351T o t a l L a b e l A L a b e l B L a b e l C L a b e l DWaterfall chart 4 PK Shapes Libarry – Charts Bar Hints: 1 Calculate and enter the value corresponding to the area below the column in the row marked Space 2 Enter the height of the column in the row marked Column row 3 Add/remove columns and rows as required 4 Add series lines between the columns manually, if required 5 To change the height of the columns select Chart Options and turn on the yaxis, then use Format Axis/Scale to set the length of the yaxis (check the “Automatic” button). Once the scale is set, use Chart Options again to remove the yaxis 5 54 43 32 21 . 5 1 . 51 . 51 . 5T o t a l L a b e l A L a b e l B L a b e l C L a b e l D L a b e l E L a b e l FWaterfall chart 5 PK Shapes Libarry – Charts Bar Hints: 1 Calculate and enter the value corresponding to the area below the column in the row marked Space 2 Enter the height of the column in the row marked Column row 3 Add/remove columns and rows as required 4 Add series lines between the columns manually, if required 5 To change the height of the columns select Chart Options and turn on the yaxis, then use Format Axis/Scale to set the length of the yaxis (check the “Automatic” button). Once the scale is set, use Chart Options again to remove the yaxis 115386T o t a l 1 L a b e l A L a b e l B L a b e l C T o t a l 2Waterfall chart 6 PK Shapes Libarry – Charts Bar Hints: 1 Calculate and enter the value corresponding to the area below the column in the row marked Space 2 Enter the height of the column in the row marked Column row 3 Add/remove columns and rows as required 4 Add series lines between the columns manually, if required 5 To change the height of the columns select Chart Options and turn on the yaxis, then use Format Axis/Scale to set the length of the yaxis (check the “Automatic” button). Once the scale is set, use Chart Options again to remove the yaxis 5493134132 211 1T o t a l 1 L a b e l A L a b e l B L a b e l C L a b e l D L a b e l E L a b e l F T o t a l 2Deviation column chart PK Shapes Libarry – Charts Bar Hints: 1 Select a data series by clicking with the right mouse button on the bar 2 Choose an overlap in the options menu 3 Add group names manually 5413Label A Label B Label C Label D Range column chart PK Shapes Libarry – Charts Bar Hints: 1 Enter the number for the space between the xaxis and the bar in the “Space“ row 2 Enter the height of the bar in the “Group 2“ row 3132343201020304050607080L a b e l A L a b e l B L a b e l C L a b e l DGrouped column chart 1 PK Shapes Libarry – Charts Bar 2027902031393532L a b e l A L a b e l B L a b e l C L a b e l DG r o u p 1 G r o u p 2Grouped column chart 2 PK Shapes Libarry – Charts Bar Hints: 1 Select a data series by clicking with the right mouse button on the bar. 2 Choose an overlap in the options menu 2027902031393532L a b e l A L a b e l B L a b e l C L a b e l DG r o u p 1 G r o u p 2Subdivided column chart PK Shapes Libarry – Charts Bar Hints: 1 Calculate the total and enter it in the Sum row (which is a transparent bar) 2 Bottom align the total value (which is a transparent bar) 4 To change the height of the columns select Chart Options and turn on the yaxis, then use Format Axis/Scale to set the length of the yaxis. Once the scale is set, use Chart Options again to remove the yaxis 2027902031393520515266125L a b e l A L a b e l B L a b e l C L a b e l DG r o u p 2G r o u p 1Subdivided 100% column chart PK Shapes Libarry – Charts Bar Hints: 1 Select Format Series Lines to add/remove trend lines 2 Edit Group names manually 27%33%64%31%41%47%25%48%32%20%11%21%L a b e l A L a b e l B L a b e l C L a b e l DGroup 3 Group 2 Group 1 Stepcolumn chart PK Shapes Libarry – Charts Bar Hints: 1 Insert columns as required (each will adopt a different color) 2 Doubleclick on a bar to change the color 3 Drag data values outside the columns manually 20272090L a b e l A L a b e l B L a b e l C L a b e l DCombination columnline chart 1 PK Shapes Libarry – Charts Bar Hints: 1 Insert columns/groups as required (each will adopt a different color) 2 Doubleclick on a column/line to change the color/ format 3 Edit the yaxis label for the line (an axis for the columns is not required as the values appear on top of the co