The first step in creating a chart is to build a worksheet that contains data to chart. Many
business charts are created from summary data. If your dataset contains transactional data,
you should also consider summarizing the data using either a pivot table or formulas.
In Figure 1.13, the original dataset contained detailed transactional data. In order to create
summary data to be used in a chart, new rows were inserted at the top of the worksheet,
and a summary table was created using the new
SUMIFSfunction. The formulas in C2:E4
create conditional sums to find the total revenue for each combination of product and year.
1
Chapter ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.