I have a worksheet with a lot of data on it (many rows and columns). I am
able to create charts with no problem. Is there a way to make a chart, that
allows you to select which data you would like to use in the chart, ie. a
specific row. Feedback is that users like the chart, but would like to break
the data up, essentially customizing for each stakeholder without creating a
new chart each time.

I am envisioning a Pivot Table like drop down list to select which data.