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)
