MS Excel Charts PDF

MS Excel Charts 1 Charts and graphs help you present and analyze data graphically, making it easier to identify trends, patterns, and comparisons. By converting numerical data into visual formats, you can communicate complex information clearly and effectively....

MS Excel Charts 1 Charts and graphs help you present and analyze data graphically, making it easier to identify trends, patterns, and comparisons. By converting numerical data into visual formats, you can communicate complex information clearly and effectively. 2 Advantages Of Charts And Graphs 1. Data Visualization: Transform raw data into visually appealing graphics. 2. Comparison: Easily compare different datasets. 3. Trend Analysis: Identify trends and patterns over time. 4. Clarity: Make data insights more accessible and understandable. 3 Chart Types in Excel 1. Column charts are used when you want to compare different values vertically side-by-side. Each value is represented in the chart by a vertical bar. If there are several series, each series is represented by a different color. 4 Chart Types in Excel 2. Line charts are used to illustrate trends over time. Each value is plotted as a point on the chart and is connected to other values by a line. Multiple items are plotted using different lines. 5 Chart Types in Excel 3. Pie charts are useful for showing values as a percentage of a whole. The values for each item are represented by different colors. Limit pie charts to eight sections. 6 Chart Types in Excel 4. Bar charts are just like column charts, except they display information in horizontal bars rather than in vertical columns. 7 Chart Types in Excel 5. Area charts are the same as line charts, except the areas beneath the lines are filled with color. 8 Chart Types in Excel 6. Scatter charts are used to plot clusters of values using single points. Multiple items can be plotted by using different colored points or different point symbols. 9 Chart Types in Excel 7. Stock charts are effective for reporting the fluctuation of stock prices, such as the high, low, and closing points for a certain day. 10 Chart Types in Excel 8. Surface chart is useful for finding optimum combinations between two sets of data. Colors and patterns indicate values that are in the same range. 11 Chart Types in Excel 9. Radar charts compare the aggregate values of multiple data series. 12 Chart Types in Excel 10. Combo Chart is the combination of two or more charts. This is used to highlight the different types of information. 13 Chart Types in Excel 11. Map charts are graphical representations that employ geographical maps as a visual backdrop to display data points or statistical information associated with specific geographic locations. 14 Chart Types in Excel 12. Donut Chart is a type of pie chart that features a hole in the center, like a donut. Donut charts present categories in the form of arcs instead of slices. 15 Chart Types in Excel 13. Bubble Chart is like a scatter plot in that it can show distribution or relationship. There is a third data set shown by the size of the bubble or circle. 16 Chart Types in Excel 14. Treemap Chart is a chart that represents hierarchical data in a tree-like diagram. As evident from the name, treemaps have data organized as branches and sub-branches. 17 Chart Types in Excel 15. Sunburst Chart is ideal for displaying hierarchical data. Each level of the hierarchy is represented by one ring or circle with the innermost circle as the top of the hierarchy. 18 Chart Types in Excel 16. Histogram Chart is a chart that plots the distribution of a numeric variable's values as a series of bars. 19 Chart Types in Excel 17. Box and Whisker Chart also known as a box plot, is a graph that shows how data is distributed. It's a useful tool for comparing data sets and identifying outliers. 20 Chart Types in Excel 17. Waterfall shows a running total as values are added or subtracted. It's useful for understanding how an initial value is affected by a series of positive and negative values. 21 Chart Types in Excel 18. Funnel Chart shows a series of steps and the completion rate for each step. 22 Create a Chart To create a line chart, execute the following steps: 1. Select the range A1:D7. 23 2. On the Insert tab, in the Charts group, click the Line symbol. 24 3. Click Line with Markers. 25 Result: Note: Enter a title by clicking on Chart Title. For example, Wildlife Population. 26 Change Chart Type You can easily change to a different type of chart at any time. 1. Select the chart. 2. On the Chart Design tab, in the Type group, click Change Chart Type. 27 3. On the left side, Result: click Column. 4. Click OK. 28 Switch Row/Column If you want to display the animals (instead of the months) on the horizontal axis, execute the following steps. 1. Select the chart. 2. On the Chart Design tab, in the Data group, click Switch Row/Column. 29 Result: 30 Legend Position To move the legend to the right side of the chart, execute the following steps. 1. Select the chart. 2. Click the + button on the right side of the chart, click the arrow next to Legend and click Right. 31 Result: 32 Data Labels You can use data labels to focus your readers' attention on a single data series or data point. 1. Select the chart. 2. Click a green bar to select the Jun data series. 3. Hold down CTRL and use your arrow keys to select the population of Dolphins in June (tiny green bar). 4. Click the + button on the right side of the chart and click the check box next to Data Labels. 33 Result: 34 Chart Elements 35 Chart Elements 1. Source data - This is the range of cells that make up a chart. The chart is updated automatically whenever the information in these cells changes. 2. Title – It offers a short explanation of what is in your graph. 3. Legend - This is the chart key, which details what each color on the chart represents. 36 Chart Elements 4. Axis - This is the vertical and horizontal parts of a chart. The vertical axis is often referred to as the Y axis, while the horizontal axis is referred to as the X axis. 5. Data series - This is the actual charted values, which usually are rows or columns of the source data. 37 Chart Elements 6. Value axis - This is the axis that represents the values or units of the source data. 7. Category axis - This is the axis identifying each data series. 38 REFERENCES: https://www.customguide.com/excel/how-to-make-a-graph-in-excel https://www.excel-easy.com/data-analysis/charts.html https://edu.gcfglobal.org/en/excelxp/creating-a-chart/1/ 39