The Pie ChartA Pie Chart displays one series of data. A data series is a row or column of NUMBERS used for charting. In the WORKSHEET below, we have outlined a single data series. If we had selected multiple series for the Pie Chart, EXCEL would ignore all but the first.Example of a single data series in an Excel worksheetSingle Data SeriesExcel uses the row heading (series identifier) for the chart title and displays the data as proportional slices of a pie (1st image below). One can customize the design of the pie chart so either numeric values or their percentages display on top of the slices of pie.The Column ChartThe Column Chart effectively compares a single set of data points, but it shines when comparing multiple series. Outlined in red, the image below shows the three data series we're charting. Notice that we do not include the totals in our data series.worksheet image showing multiple data series of Flowers, Shrubs, and TreesMultiple Data SeriesBecause Excel uses a different color for each data series, it's easy to see how a single series changes over time, or compare multiple series over a given time period. The Clustered Column Chart is ESPECIALLY popular.Clustered column chartThe Line Chartpicture of a line chart with markersThe Line Chart is especially effective in displaying trends. The VERTICAL axis (Y-axis) always displays numeric values and the horizontal axis (X-axis) displays time or other category.The first image shows the Line with Markers chart of our single data series. Markers—the circles, squares, triangles, or other shapes which mark the data points—are optional, and Excel displays a unique marker in shape and/or color for each data series.