•1 min read•from 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.
[link] [comments]
Want to read more?
Check out the full article on the original site
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