excel eval chart features

line chart is used for

trends over time

column chart is used to

compare items in a specific range of value ( comparing revenue between regions)

stacked column chart used for

comparing items in a specific range of values as well as showing the relationship of individual sub-items ( proportion of total revenue made by each region)

pie chart used to

represent distribution or proportion of each data itme over total value

• do not plot more than 3 values

bar charts used to

compare several categories of data

area chart ideal for

clearly illustrating magnitude of change between 2 or more data points ( degree of variance between high and low price for each month)

combination chart ideal for

Combining two or more chart types into a single chart. Want to compare 2 categories of each individual sub item

stacked column chart is only used when values are

added together

bar charts are ideal for

visualizing the distribution of data items when there are more than 3 categories ( overall venue for given set of products)