1、 Excel Charts i About the Tutorial A chart is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier. In this tutorial, you will learn how to insert charts and modify them
2、 so they communicate information effectively. Each of Excels 12 chart types has different features that make them better suited for specific tasks. Pairing a chart with its correct data style will make the information easier to understand, enhancing the communication within your small business. Audi
3、ence Graphs or charts help people understand data quickly. Whether you want to make a comparison, show a relationship or highlight a trend, they help your audience “see” what you are talking about. Among its many features, Microsoft Excel enables you to incorporate charts, providing a way to add vis
4、ual appeal to your business reports. Prerequisites Before you start proceeding with this tutorial, we are assuming that you are already aware of the basics of Microsoft Excel. If you are not well aware of these concepts, then we will suggest you to go through our short tutorials on Excel. Copyright
5、& Disclaimer Copyright 2016 by Tutorials Point (I) Pvt. Ltd. All the content and graphics published in this e-book are the property of Tutorials Point (I) Pvt. Ltd. The user of this e-book is prohibited to reuse, retain, copy, distribute or republish any contents or a part of contents of this e-book
6、 in any manner without written consent of the publisher. We strive to update the contents of our website and tutorials as timely and as precisely as possible, however, the contents may contain inaccuracies or errors. Tutorials Point (I) Pvt. Ltd. provides no guarantee regarding the accuracy, timelin
7、ess or completeness of our website or its contents including this tutorial. If you discover any errors on our website or in this tutorial, please notify us at Excel Charts ii Table of Contents About the Tutorial . i Audience . i Prerequisites . i Copyright & Disclaimer . i Table of Contents . ii 1.
8、 Excel Charts Introduction . 1 Charts Group . 1 Chart Tools. 2 Recommended Charts . 2 2. Excel Charts Creating Charts . 4 Creating Charts with Insert Chart . 4 Creating Charts with Recommended Charts . 6 Creating Charts with Quick Analysis . 9 3. Excel Chart Types . 13 Column Chart . 13 Line Chart .
9、 14 Pie Chart . 14 Doughnut Chart . 14 Bar Chart . 14 Area Chart. 15 XY (Scatter) Chart . 15 Bubble Chart . 16 Stock Chart . 16 Surface Chart . 17 Radar Chart . 17 Combo Chart. 17 4. Excel Charts Column Chart . 18 Clustered Column and 3-D Clustered Column . 20 Stacked Column and 3-D Stacked Column .
10、 21 100% Stacked Column and 3-D 100% Stacked Column . 21 3-D Column . 22 5. Excel Charts Line Chart . 23 Line and Line with Markers . 25 Stacked Line and Stacked Line with Markers . 26 100% Stacked Line and 100% Stacked Line with Markers . 27 3-D Line . 28 6. Excel Charts Pie Chart . 29 Pie and 3-D
11、Pie. 31 Pie of Pie and Bar of Pie . 32 7. Excel Charts Doughnut Chart . 34 Excel Charts iii 8. Excel Charts Bar Chart . 37 Clustered Bar and 3-D Clustered Bar . 39 Stacked Bar and 3-D Stacked Bar. 40 100% Stacked Bar and 3-D 100% Stacked Bar . 41 9. Excel Charts Area Chart . 42 Area and 3-D Area . 4
12、4 Stacked Area and 3-D Stacked Area . 45 100% Stacked Area and 3-D 100% Stacked Area . 46 10. Excel Charts Scatter (X Y) Chart . 47 Scatter Chart . 50 Types of Scatter Charts . 50 11. Excel Charts Bubble Chart . 53 Bubble and 3-D Bubble . 55 12. Excel Charts Stock Chart . 56 High-Low-Close . 58 Open
13、-High-Low-Close . 58 Volume-High-Low-Close . 59 Volume-Open-High-Low-Close . 60 13. Excel Charts Surface Chart . 61 3-D Surface . 63 Wireframe 3-D Surface . 64 Contour . 65 Wireframe Contour . 66 14. Excel Charts Radar Chart . 67 Radar and Radar with Markers . 69 Filled Radar . 69 15. Excel Charts C
14、ombo Charts . 70 Clustered Column Line . 72 Clustered Column Line on Secondary Axis . 72 Stacked Area Clustered Column . 73 Custom Combo Chart . 74 16. Excel Charts Chart Elements . 76 Axes . 79 Axis Titles . 80 Chart Title . 83 Data Labels . 85 Data Table. 87 Error Bars . 88 Gridlines . 90 Legend . 92 Trendline . 93 17. Excel Charts Chart Styles . 94 Style .
