One Chart with OffSet and Match Functions|Dashboards & Charts|Excel Forum|My Online Training Hub

Hello Mynda,

I just created a chart using Offset and Match Function. I can see data for A to M in my chart. I used Dropdown for Column B to F.

Now my question is that how do I see data for the individual customers? I just want to see all the information for Customer A. In Pivot Table I use Slicers. I tried to use Slicers by making this range a table and it works but there is no link between the beautiful chart I made with Offset and Match Function. In Pivot Tables, you can connect to both but not over here. Maybe I am confused. I just started with Excel for the past few months.

I don't want to create 2 Charts. I want to create one chart only but I would like to see data Vertically and Horizontally as well. I hope I am clear?  I can transpose this data and then I can achieve but again there will be 2 charts. How can I achieve this in one chart?

This is not Pivot Table. This is just plain range.

Thanks,

PB