PPT素材大全-横向柱状图

Group 1 Label D 20
Group 2 32 52
Label C
90
35
125
Label B
27
39
66
Label A
20
31
51
© Accenture 2004. All Rights Reserved.
4
Quick Presentation Toolkit
Sub-divided 100% bar chart
Hints: 1 Select Format Series Lines to add/remove trend lines 2 Add legend names manually
Group 1 Label D 31%
Group 2 48%
Group 3 21%
Label C
64%
25%
11%
Label B
-3 Label D
Label C
-1
Label B
4
Label A
5
© Accenture 2004. All Rights Reserved.
0
Quick Presentation Toolkit
Range bar chart
Hints: 1 Enter the number for the space between the y-axis and the bar in the “Space“ row 2 Enter the width of the bar in the “Group 2“ row
Deviation bar chart
Hints: 1 Insert rows as required (each will adopt a different color) 2 Double-click on a bar to change the color 3 Drag data values outside the rows manually 4 Add labels manually
Label D
32
Label C
34
Label B
32
Label A
31
0
10
20
30
40
50
60
70
80
© Accenture 2004. All Rights Reserved.
1
Quick Presentation Toolkit
Sliding bar chart
Hints: 1 Insert rows as required (each will adopt a different color) 2 Double-click on a bar to change the color 3 Drag data values outside the columns manually 4 Add labels manually 5 To change the width of the rows select Chart Options and turn on the x-axis, then use Format Axis/Scale to set the length of the x-axis. Once the scale is set, use Chart Options again to remove the x-axis
Label D
-2
4
Label C
-3
2
Label B
-1
3
Label A
-2
1
© Accenture 2004. All Rights Reserved.
2
Quick Presentation Toolkit
Paired bar chart
Hints: 1 This chart is made of two graphs. Start with the left one, it contains the axis titles 2 To change the width of the rows select Chart Options and turn on the x-axis, then use Format Axis/Scale to set the length of the x-axis. Once the scale is set, use Chart Options again to remove the x-axis
33%
47%
20%
Label A
27%
41%
32%
© Accenture 2004. All Rights Reserved.
5
Quick Presentation Toolkit
Grouped bar chart
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
32
LLabel B
30
35
Label C
35
27
Label D
27
© Accenture 2004. All Rights Reserved.
3
Quick Presentation Toolkit
Sub-divided bar chart
Hints: 1 Calculate the total and enter it in the "Sum" row (which is in a transparent bar) 2 Left align the total value (which is in a transparent bar) 3 Add the legend names manually 4 To change the width of the rows select Chart Options and turn on the x-axis, then use Format Axis/Scale to set the length of the x-axis. Once the scale is set, use Chart Options again to remove the x-axis
32 Label D 20
35 Label C 90
39 Label B 60
31 Label A 20 Group 1 Group 2
© Accenture 2004. All Rights Reserved.
6
Quick Presentation Toolkit