Hi
I've just watched your video 'Trick Excel into creating regular charts from PivotTables' and would LOVE to able to able to replicate it within my report - I currently have to update my feeder table manually in order to generate my chart.
Is it possible to create a dynamic named range covering multiple columns that enables each column to be plotted individually on the chart and that will respond to updates in the pivot table and the use of slicers?
many thanks
Hi Julie,
Yes, you would have to create a separate dynamic named range for each contract column and another for the months. See session 3.75 of the Excel Expert course.
That said, why don't you use Pivot Chart? There's nothing special about the example chart in your file that means you have to use a regular chart. I would only use a regular chart if you absolutely can't use a Pivot Chart.
Plus if you're going to use a Slicer to filter which contracts appear in the chart, it will cause problems because some dynamic named ranges will return empty ranges when the contract in that particular column is empty due to Slicer selections.
Mynda
