clickable graph to drill down into data (like Tableau)
Sorry if this is a repeat, the search function on this site is.... sub-par.
In addition to being able to assign hover/ mouse-over tips on graphs, it would be great if Excel could natively collect and expose information from graph selections to be used in VBA or maybe even in formulas (e.g. link to a cell, so that whatever point is selected on a graph then shows up in the cell and can drive other formula activity). This would allow workbook designers to natively create more interactive dashboards that control drill-down tables or graphs. This functionality has been created with add-ins (and not that much code) but having it in the Excel code base would allow far more functionality and faster/easier development