Cross filter visuals in Excel | Amazing interactive charts | Excel Off The Grid

[@ziggle314]

Superb. My organization prefers that everything be in Excel because everyone has access to it. This type of exposition really helps those of us in this situation. Thanks.

[@ExcelOffTheGrid]

Well, I hope you can put it to good use and make some nice interactive reporting.

[@IvanCortinas_ES]

Absolute mastery in achieving this graph and slicer effect. Thanks for sharing, Mark.

[@kashmoney1]

Thanks bro... Can you make a video of the python in Excel?

[@ExcelOffTheGrid]

I'll still waiting to see where the real value is from using the new Python in Excel. Once I've established that, I'll definitely make some videos.

[@bertbakker4374]

What a super video Mark! Is it also possible to include columns year and quarter here? In what way should this be done?

[@arindambhattacharya8127]

what is the use of this light grey color in the chart bars? what does that represent? I think it is only "selected" values that should appear in the chart..why is the grey portion "unselected" appearing? It is wrong representation

[@ExcelOffTheGrid]

The light grey is the total value.
For example the left chart is the total value of all regions broken down by item. By "cross-filtering" from the chart on the right, we can see how much of each item is North, South, East, West, or any combination of these.
These types of visuals are common in Business Intelligence software.

[@arindambhattacharya8127]

@@ExcelOffTheGrid can you please share the excel you used?

[@TheBtrivedi]

Thank you so much. Great start of my Friday morning.

[@ExcelOffTheGrid]

You're welcome. I'm glad you enjoyed it.

[@SeanThelwell-q2j]

Thank you, great job, just used this to creat a Power BI look alike dashboard for PMO Dept. Great stuff.

[@ExcelOffTheGrid]

Fantastic! That's great news, I hope it goes down well.

[@Fabi_terra]

Your tutorial and solutions were amazing! Thank you so much, and congratulations on your fantastic presentation style.

[@ExcelOffTheGrid]

Thanks Fabi - I really appreciate that. 😁

[@ivanrodrigo87]

MUCHAS GRACIAS,.!!

[@ExcelOffTheGrid]

You’re welcome.

[@rigobertogarcia]

Fantastic Mark. Incredible everything that can be learned with this great video that you have published. Thank you very much for sharing so much knowledge.

[@ExcelOffTheGrid]

Thank you. Yes, lots of interesting techniques in there. When they are combined in the right way 💥

[@jc6830]

14:45 presentation

[@ismaelkourouma5558]

Awesome 👏 !

[@ExcelOffTheGrid]

Thank you! 😁

[@kebincui]

Thanks Mark.Excellent as always👍

[@ExcelOffTheGrid]

Thanks Kebin 😁

[@amosarubi8468]

Your white hair fits you well. Excellent work, and thanks for sharing.

[@ExcelOffTheGrid]

Thanks 😊

[@vacilando86]

That’s very very smart method. Really respect buddy.

[@ExcelOffTheGrid]

Thank you, I’m glad you liked it.

[@cedjulemckeever]

Great video. There is a lot to learn here. I will have to watch this video several times.

[@ExcelOffTheGrid]

Thanks. There are several useful techniques in here. The key thing is putting them together in the right way.
These are all techniques we cover in our training program.

[@nsanch0181]

Thank you for the beautiful slicer video. I really like that technique you used on the data; include using the subtotal, and the selected vs unselected items. Neat concept.

[@ExcelOffTheGrid]

Thanks. Hopefully it's given you a few ideas of how you can use it in your work.

[@spilledgraphics]

Oh my , oh my, oh my !! amazing Mark!

[@ExcelOffTheGrid]

Thanks Carlos. Though, knowing your style, I suspect you would have used a PivotTable with the Slicers, instead of a Table. 😁