You cannot create a scatter chart based on a pivot table.Although scatter charts are best for stratifying data,you can still
achieve the same effect by using a pivot chart.
During the process of building a pivot chart,there are two steps during which you might temporarily have thousands of
data points along the axis field.Rather than ask Excel to attempt to render a chart with thousands of data points,it
would make more sense to build the analysis as a pivot table first,group the fields,and then convert it to a pivot table.
You follow these steps to analyze invoice sizes for the five largest customers in your ...
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.