Select . Excel 16.37 will suggest the best format (e.g., Column, Line, or Pie) based on your data structure.
For more complex pieces, such as a summary report from a large dataset: Click anywhere in your data table. Go to .
: Place descriptive titles in the first row (e.g., Date, Category, Amount).
In the side panel, drag your categories to "Rows" and your numbers to "Values." This quickly produces a summarized "piece" of information without manual formulas. Important Technical Considerations