Error - data source not valid

Copper Contributor

I am trying to make a sparkline with a pivot table full of data, and I am trying to follow along with a tutorial to make a dashboard in excel but I can't progress because of this error. this is the tutorial. Around the 29 min mark he presses the line chart sparkline and a chart is made for all of the data rather than just a small amount of data. I've been doing research but I can't find a solution to this error. thank you for trying to help!  

1 Reply


Perhaps you may ask direct question what you'd like to do, desirably with small sample file. Making the guesses how you data is actually structured and is it in sync with this or that presentation is not very productive.