Pie Charts have two common pitfalls:
If you ever run into this issue, a bar chart may be the best solution. The picture comparing pie charts and bar charts shows why.
With each pie chart, it is almost impossible to compare separate sectors. However, the bar chart makes the comparisons much easier to decipher.
Bar Charts and Pie Charts are used to visualize categorical data. Both types of graphs contain variations as displayed in the visual.
A line chart or sparkline is useful for analyzing trends in data over time.
A scatterplot visually represents connections between two numeric variables.
Excel can create column (or bar) charts, histograms, scatterplots, line charts, and pie charts from a table of data.
Excel can color tables using one color for data within an acceptable range and another for data outside an acceptable range.
Excel can color tables of numeric data using darker shades for larger numbers and lighter shades for smaller numbers (a heatmap or color scale).