Chart based on Store selection

[IvanYerk]

I rarely post questions on here as I've so often been able to find posts on how to solve my problem. In this case, I'm struggling. I want to chart data based on the selection of a Store. How do I do this?

[TABLE="width: 497"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Gross Sales[/TD]
[TD="align: right"]Oct-18[/TD]
[TD="align: right"]Nov-18[/TD]
[TD="align: right"]Dec-18[/TD]
[TD="align: right"]Jan-19[/TD]
[/TR]
[TR]
[TD]Store A[/TD]
[TD="align: right"] 79,942[/TD]
[TD="align: right"] 74,361[/TD]
[TD="align: right"] 75,260[/TD]
[TD="align: right"] 71,771[/TD]
[/TR]
[TR]
[TD]Store B[/TD]
[TD="align: right"] 70,669[/TD]
[TD="align: right"] 65,432[/TD]
[TD="align: right"] 77,234[/TD]
[TD="align: right"] 67,521[/TD]
[/TR]
[TR]
[TD]Store C[/TD]
[TD="align: right"] 43,685[/TD]
[TD="align: right"] 42,508[/TD]
[TD="align: right"] 56,921[/TD]
[TD="align: right"] 38,843[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 814"]
<colgroup><col><col><col><col><col span="2"><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[igold]

I think your problem lies in how you have your data laid out. If it were me, I would have 3 Columns of data. The header row would be STORE#, DATE, SALES. I would then move the sales data to the appropriate corresponding cells.

With your data set up like this you can create a pivot table and then a pivot chart off of the pivot table. Once that is done you can filter the pivot table by whatever store or stores you want and the chart will automatically update. You can even filter by store right on the chart itself.

 

[Jon Peltier]

You can take the data just as you have, and convert the range into a Table. Select the range, press Ctrl+T, check my data has headers. I changed "Gross Sales" to "Store".

Then make a chart from the Table, switching rows and columns if necessary.

Add a slicer to the Table, link it to the Store field. When you use the slicer, the unselected rows are hidden, and only the visible ones appear in the chart.