I think this is an extremely tough one, so I apologize in advance. We've been working for weeks to try to automate the creation of something like the attached JPEG file, which we create in PowerPoint. We manually update it and it is cumbersome and causes much data entry error.
A typical data set would like like this:
Team | Win Percent | Prep Time (0-100)
Team A | 1% | 1
Team L | 25% | 80
Team HH | 99% | 90
The desired display is too difficult to explain - that's why I attached the file.
We've tried bubble charts and bar charts of all styles, but nothing seems to be flexible enough for what we need.
ANY help is greatly appreciated, we're stuck!
Thanks in advance.
Bookmarks