Creating Dashboard using multiple Team

Hello Team,

I need to create a Dashboard for Monthly Financial actuals v/s forecast for around 4 project using the Master sheet and i need Bar or any chat with the above metrics.

Example - Client should be able to see the Chat with Monthly Financial status for all the projects like A,B,C,D projects.

Let me know if we can create Dashboard for the above requirement