25 thoughts on “? How to Build Excel Interactive Dashboards”

  1. So, I have one roadblock with this. My data is kept horizontally, as it is easier to see and enter at a glance, but I want to transpose it first. Is there a way to transpose the data from a horizontal format to a vertical format, then make the table and pivot? I cannot seem to find a work around to making an interactive live dashboard, while also maintaining the data horizontally. I have already tried the transpose function to turn the data into an array that would update automatically.

Comments are closed.