What kinds of charts are in Excel?

Answer 1

Although Microsoft uses its own names or some, they are principally Cartesian (rectangular), "Radar" (a rather poor type of polar graph with a serious lack of axis-editing functions and a bizarre division of 360º and 0º into two separate points), Pie and Bubble. The last two are more for general presentation than serious mathematical uses. Earlier versions of 'Excel' also included Cone Charts - also a presentation rather than analytical tool - but I'm not sure if these are still offered. They have bar charts, column charts and area charts and also stock charts.

Within these, 'Excel' offers a fairly wide range of detailed versions including combined line-&-column charts and 3-D illusions. Unfortunately, as someone who uses MS 'Excel' spreadsheets and graphs professionally as well as for hobby purposes, the latest versions and their editing functions are over-designed, with vague menus often difficult to find, useful functions removed or cut back and assumptions on use that do not necessarily allow the users the flexibility they need for their own data and purposes.

Answer 2

A chart is a graphical representation of data. There are many different kinds, much more than 4. The main ones would be bar, column, pie and line, which would be the 4 you mean. There are more though, like XY, Area, Stock, Bubble and others.

Answer 3

· An area chart emphasizes the magnitude of change over time. By displaying the sum of the plotted values, an area chart also shows the relationship of parts to a whole.

· A Column Chart shows data changes over a period of time or illustrates comparisons among items. Categories are organized horizontally, values vertically, to emphasize variation over time. Stacked column charts show the relationship of individual items to the whole. The 3-D perspective column chart compares data points along two axes.

· A Bar Chart illustrates comparisons among individual items. Categories are organized vertically, values horizontally, to focus on comparing values and to place less emphasis on time. Stacked bar charts show the relationship of individual items to the whole.

· A Line Chart shows trends in data at equal intervals.

· A Pie Chart shows the proportional size of items that make up a data series to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element. To make small slices easier to see, you can group them together as one item in a pie chart and then break down that item in a smaller pie or bar chart next to the main chart.

· Like a pie chart, a Doughnut Chart shows the relationship of parts to a whole, but it can contain more than one data series. Each ring of the doughnut chart represents a data series.

· The High-Low-Close Chart is often used to illustrate stock prices. This chart can also be used for scientific data, for example, to indicate temperature changes. You must organize your data in the correct order to create this and other stock charts. A stock chart that measures volume has two value axes: one for the columns that measure volume, and the other for the stock prices. You can include volume in a high-low-close or open-high-low-close chart.

· An XY (Scatter) Chart either shows the relationships among the numeric values in several data series or plots two groups of numbers as one series of xy coordinates. This chart shows uneven intervals - or clusters - of data and is commonly used for scientific data. When you arrange your data, place x values in one row or column, and then enter corresponding y values in the adjacent rows or columns.

· A Bubble Chart is a type of xy (scatter) chart. The size of the data marker indicates the value of a third variable. To arrange your data, place the x values in one row or column, and enter corresponding y values and bubble sizes in the adjacent rows or columns.

· In a Radar Chart, each category has its own value axis radiating from the center point. Lines connect all the values in the same series. A radar chart compares the aggregate values of a number of data series. In this chart, the data series that covers the most area, Brand A, represents the brand with the highest vitamin content.

· A Surface Chart is useful when you want to find optimum combinations between two sets of data. As in a topographic map, colors and patterns indicate areas that are in the same range of values.

Answer 4

1. column chart

2. line chart

3. pie chart

4. bar chat

5. area chat

6. stock chart

7. surface chart

8. bubble chart

Answer 5

There are many types. Some include Bar charts, Column charts, Line charts, Pie charts, XY charts, Stock charts, Area charts, Bubble charts and many others.