Charts and graphs in excel

this ppt is about charts in ms excel.there are many types of chart used in ms excel but in this ppt some common types are defined,as line chart,bar,column,area ,scatter chart etc...

1. CHARTS AND GRAPHS IN EXCEL PRESENTED BY: ASIYA SALEEM IQRA NEHAL SANISH MEMON MARYAM SAEED SANIA RAHEEM

2. CONTENTS : Introduction to charts. Types of charts. How to create/insert charts in EXCEL. Importance of charts/graphs… References..

3. A ‘chart’: “Any data which is represented graphically” OR “Diagram or graph that organizes and represents a set of numerical or qualitative data.”

4. TYPES OF CHART: Scatter chart Stock Surface Doughnut Bubble Radar histogram

5. Common TYPES OF CHARTS PIE CHART: BAR CHART: COLUMN CHART: AREA CHART: LINE CHART:

6. COLUMN CHART; Shows the comparison between one or more series of data point. STACKED : two comparisons of data points for time periods are stacked. CLUSTERED: comparison of three data series for each time period.

7. PIE CHART; Another frequently used chart is the pie chart. A pie chart represents the distribution or proportion of each data item over a total value(represented by the overall pie).

8. BAR CHART; A bar chart or bar graph is a chart that represent categorical data with rectangular or vertical bars.

9. AREA CHART; Area charts are like line charts except that the area below the plot line is solid. And like line charts ,area charts are used primarily to show trends over time or other category .

10. LINE CHART: It is a type of chart that displays information as a series of data points called “markers” connected by a straight line segments. It is often used to visualize a trend in data over Intervals of time.

11. HOW TO INSERT A CHART:

12. IMPORTANCE OF CHARTS/GRAPHS: Remember:: ‘A PICTURE IS WORTH A THOUSAND WORDS’

13. 1. https://www.keynotesupport.com/excel-basics/excel-chart-types.shtml 2. https://www.google.com.pk/search?q=charts+and+graphs+in+excel&rlz

14. THANK YOU ! !