ANU First Semester Information technology July 2021

ANU First Semester Information technology July 2021

ANU-First-Semester-Information-technology-July-2021

ANU First Semester Information technology July 2021 previous question papers

For More ANU Degree Papers Click Here

ANU Official Website Click Here

Write about Different type of charts in MS Excel.

Microsoft Excel is a popular spreadsheet program that allows users to organize, analyze and visualize data using various chart types. Below are some of the commonly used chart types in MS Excel.

1. Column Chart: Column charts are used to display comparisons between data points by using vertical columns. They are often used to show changes in data over time or to compare categories.
2. Bar Chart: Bar charts are similar to column charts, but they use horizontal bars instead of vertical columns. They are often used to display data that has long category labels.
3. Line Chart: Line charts are used to display trends in data over time. They use a continuous line to connect data points.
4. Pie Chart: Pie charts are used to display the proportion of each category in a dataset. They use a circular format and are divided into slices, with each slice representing a category.
5. Scatter Plot: Scatter plots are used to display the relationship between two variables. Each point represents a data point and the position of the point on the graph indicates the values for each variable.
6. Area Chart: Area charts are similar to line charts, but the area below the line is filled with color. They are often used to display cumulative data.
7. Radar Chart: Radar charts are used to display data with multiple variables. The chart is circular and each variable is represented by a spoke on the chart.
8. Stock Chart: Stock charts are used to display the performance of a stock or other financial instrument over time. They include high, low, open, and close values.
9. Surface Chart: Surface charts are used to display three-dimensional data. They use colors to represent different data values on the z-axis.
10. Bubble Chart: Bubble charts are used to display three-dimensional data, similar to a scatter plot. They use bubbles of different sizes to represent different data values.

These are just a few examples of the many chart types available in Microsoft Excel. Choosing the right chart type depends on the data being analyzed and the message you want to convey.