March 8, 2021
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.
July 16, 2010
I'm not sure why you would go to all this hassle with formulas when you can use a PivotTable after using Power Query to unpivot your data. If you still want to use formulas, please upload a file showing the OFFSET formulas etc. and chart you've created so far, so I don't have to recreate everything.