the ___________ chart can represent only one data series
Answers
Explanation:
Data that is arranged in columns or rows on a worksheet can be plotted in a line chart. In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis. Line charts can show continuous data over time on an evenly scaled axis, and are therefore ideal for showing trends in data at equal intervals, like months, quarters, or fiscal years.
Line with markers chart
Types of line charts
Line and line with markers Shown with or without markers to indicate individual data values, line charts can show trends over time or evenly spaced categories, especially when you have many data points and the order in which they are presented is important. If there are many categories or the values are approximate, use a line chart without markers.
Stacked line and stacked line with markers Shown with or without markers to indicate individual data values, stacked line charts can show the trend of the contribution of each value over time or evenly spaced categories.
100% stacked line and 100% stacked line with markers Shown with or without markers to indicate individual data values, 100% stacked line charts can show the trend of the percentage each value contributes over time or evenly spaced categories. If there are many categories or the values are approximate, use a 100% stacked line chart without markers.
Notes:
Line charts work best when you have multiple data series in your chart—if you only have one data series, consider using a scatter chart instead.
Stacked line charts add the data, which might not be the result you want. It might not be easy to see that the lines are stacked, so consider using a different line chart type or a stacked area chart instead.
Top of Page
Pie and doughnut charts
Data that is arranged in one column or row on a worksheet can be plotted in a pie chart. Pie charts show the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are shown as a percentage of the whole pie.
Pie chart
Consider using a pie chart when:
You have only one data series.
None of the values in your data are negative.
Almost none of the values in your data are zero values.
You have no more than seven categories, all of which represent parts of the whole pie.
Types of pie charts
Pie Pie charts show the contribution of each value to a total in a 2-D format.
Top of Page
Doughnut charts
Data that is arranged in columns or rows only on a worksheet can be plotted in a doughnut 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.
Doughnut chart
Types of doughnut charts
Doughnut Doughnut charts show data in rings, where each ring represents a data series. If percentages are shown in data labels, each ring will total 100%.
Note: Doughnut charts are not easy to read. You may want to use a stacked column or stacked bar chart instead.
Top of Page
Bar charts
Data that is arranged in columns or rows on a worksheet can be plotted in a bar chart. Bar charts illustrate comparisons among individual items. In a bar chart, the categories are typically organized along the vertical axis, and the values along the horizontal axis.
The Pie chart can represent only one data series.
- It is a circular graph that is more accurate in representing parts of a whole.
- It is divided into slices or areas, each of which is a percentage of the entire thing and is useful for making comparisons and showing relative data.
- There are different styles of Pie charts like Doughnut charts, Spie charts, etc.
- These charts do not support the representation of multiple variables.