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. https://www.youtube.com/watch?v=m13o5aqeCbM&t=1751s 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!
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.