•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How can I create a chart based off my dropdown list?
Hello, everyone I'm quite new to spreadsheets. I'm trying to create a chart that displays the stock values under the specific category it falls under (shipped, received, in transit).
For example, depending on if I selected in transit, shipped, or received, I'd like for the chart to dynamically change the values it displays for each category. It would be displaying the remaining stock in cells c1 to c21.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#natural language processing for spreadsheets
#Excel alternatives for data analysis
#generative AI for data analysis
#rows.com
#big data management in spreadsheets
#AI-native spreadsheets
#Excel compatibility
#financial modeling with spreadsheets
#predictive analytics in spreadsheets
#cloud-based spreadsheet applications
#chart
#dropdown list
#stock values
#category
#in transit
#shipped
#received
#spreadsheet
#dynamically
#remaining stock