If you want to impress your friends and colleagues, you can make an Excel chart change based on a drop ... the data you ...
To create a chart in an Excel report sheet ... If you want a different analysis, just select the drop-down arrow next to the item in the Values pane, then select Value Field Settings.