Making a chart from a single table no pivot table

Hello,

if I understand correctly, you want to create many charts from data that is summarised in a pivot table. A chart is tied to its underlying data source. If the data changes, the chart changes.

So, yes, if you want to see all charts at once, each chart will need to have a data source with the data for just that chart. That can be done with pivot tables or with other techniques, like formulas or named ranges.

Pivot tables are useful when you only want to see one chart at a time and let the user change the filter for the pivot table. This is often used in dashboards.

In order to see all charts for all possible filter settings, yes, you'd need to create a data table for each chart.

cheers, teylyn