1 min readfrom 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).

https://preview.redd.it/8d50q5rjvehg1.png?width=804&format=png&auto=webp&s=4eed021fda475ac1fab789bbdee154f24d04a436

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.

submitted by /u/Rough-Ostrich-8671
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article