Forum

Notifications
Clear all

One Chart with OffSet and Match Functions

2 Posts
2 Users
0 Reactions
87 Views
 P B
(@peace)
Posts: 34
Trusted Member
Topic starter
 

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

 
Posted : 19/04/2021 3:39 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi PB,

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.

Thanks,

Mynda

 
Posted : 19/04/2021 7:08 pm
Share: