1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Trying to make a “dynamic” chart for a competition in Excel

As title says. My supervisor tasked me to make a chart that can be used to track how many of our contractors are referring cases towards us.

I already have a chart that updates as other workers add in referred case load and a way to highlight the highest value on the chart.

But I want to show a way that dynamically shows who the current contractor has the highest amount of cases referred and what that number is, if that is even is a way. Think like a “current 1st place”. I think also a top three chart wouldn’t be a bad idea either. Whichever is easiest.

I’m still relatively new to excel so please explain like I don’t know what I’m doing.

submitted by /u/Slowmojoe23
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel
#dynamic chart
#referring cases
#contractors
#current contractor
#top three chart
#case load
#highest value
#tracking
#highlight
#1st place
#competition
#add cases
#performance metrics
#case tracking