Pivot Chart in Excel 2016 does not have dynamic range

Occasional Visitor

I have created a chart from a pivot table by clicking into the pivot table, going to the insert tab and creating a chart. The chart is created but when I slice the pivot table the chart range does not adjust giving me a line graph that is half blank space half data. Any suggestions? (FYI: I have already tried using offset to create a dynamic range for the chart, I cannot get it to accept the name of the range as the chart range)

0 Replies