Wondering if there is any suggestion to achieve the below:
1. Currently I am putting together a dash board like one example of the below
There is a background photo
Each module has an "Object - Shape" above the background photo with transparent colour
Each module has a chart that shows the analysis, data is linked to pivot table
All the table with quantitative data are all fine. Chart linked to pivot table in another tab and pivot just needs refresh when someone updated underlying data.
However there is one table with only text and, the current approach is, I created a classic pivot to replicate same format as the underlying text table. The copy and paste into image to include in the below dashboard.
Reason been - I cant link cell within this dashboard to the underlying table because these transparent shapes are above cells and will cover text
Wondering what's the best approach to create a "text only" table and place within one of these modules within the dashboard where table is linked to another table in another tab where people update that table and this dashboard will get refreshed.