Pie chart shows numerical proportions using circular sectors. Data visualized in values, sector labels in names. Same values in names group lines together in same sector
Line graph shows quantitative data changes over time. Contains horizontal x-axis and vertical y-axis. Data points are connected by straight lines. Axes typically intersect at (0,0)
Line chart displays data points connected by straight line segments. Early line charts credited to Hauksbee, Cruquius, Lambert and Playfair. Playfair created first time series visualization in 1786
Excel 2013-2019 introduced Combo charts for combining different data types. Average lines can be added using formulas or directly in charts. Target lines can be plotted by entering target values in last column
Creates unlimited pie charts with customizable rows and columns. Each slice is colored and ordered based on data entry. Hovering shows original values and automatically calculated percentages
Excel can be accessed through desktop app or Microsoft Office 365 subscription. New blank workbook or existing spreadsheet can be used. Data should be organized in columns for each line to plot. Column headers should be labeled in row 1 for legend