Chart and Web Objects
Introduction :- Chart is a graphical presentation of numeric data. The range of data related to a number is called a data series, each value of a data series is called a data point. Data can be kept in series, column and rows.
Type of Charts
Based on the performance of the chart, there are two types of charts-
Embedded chart and sheet chart, Embedded chart is on the same sheet, which contains data and sheet chart is a separate sheet, which contains only chart.
Part of a chart
A chart usually consists of parts called Chart area, Plot area, Legend, Legend entry, Legend key, Value (Y) axis, Category (X) axis, Chart title, Value axis title, Data series, Label, Data points, Data table. Is.
MS Excel provides us with different types of charts, each of which has at least one subtype, we can also change our chart to make it more clear and effective.
Area Chart
This chart shows the extent of the change, it is a stack line chart. Here the area between the lines is filled with color and shading. All series are built one after the other.
Bar Chart
Bar chart shows the comparison between specific items. Values are organized in horizontal and category, vertical form to present the values in comparative form and to be less dependent on time. When does this chart give on time?
Column Chart
This chart is made up of a series of horizontal or vertical columns, which present the comparison of two or more related objects.
Line Chart
In this each data series is like different types of colors and shading line.
Pie Chart
This chart is best for comparing percentages of additions to data series. This chart shows only one data series.
Doughnut Chart
This chart is also similar to the pie chart, but it shows more than one data series.
radar chart
Each category has its own value axis in the radar chart. which radiates from the focal point. All data series are connected by lines.
XY-Scatter
XY-Scatter displays either the relationship between numeric values of different data series, or plots the numbers as a series of XY-Coordinates of two groups. This chart displays Uneven intervals or clusters of data, and is used for scientific data. If you organize your data, then keep X-Values in one row or column and then keep Y-Values in the remaining row or column.
bubble chart
This chart shows the data series as a bubble.
Cylinder Chart
This chart displays the value of the data series as a cylinder.
Cone chart
This chart displays the value of the data series as a cone.
Pyramid chart
This chart presents the value of the data series in the shape of a pyramid.
Surface Chart
The surface chart shows the trends across two dimensions with a continuous rotation. Surface charts are available in many forms.
