Sure.
It's just a question of what you choose to have in your Pivot Table.
Your original post talked about seeing a single line, so I thought that was all you wanted.
Take a look at this version where I have added an extra sheet called Store Charts.
Here, when you select just an area you see a line for each store within that area, which can look very busy.
But you can just select one store, then hold down Control as you select another store. As soon as you release the Control button, that store appears as well. Continue for whatever stores you want, and the average - as in the sample as posted.
Clicking the "x on Slicers clears that selection.
I have shown the PT below the graph, as I often like to see the numeric data as well, but you don't have to have the Pt on the sheet at all.
Bookmarks