<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
I was wondering how to create a chart that would change as I choose a different value from a dropdown box. <br />
<br />
I have other infomation in my sheet updating using an INDEX(Match) function. I cannot figure out a way to make a chart that will change based on the value changing from the dropdown. All of the informatin will be coming from one sheet.
</div>
</div>


I was wondering how to create a chart that would change as I choose a different value from a dropdown box. 

I have other infomation in my sheet updating using an INDEX(Match) function. I cannot figure out a way to make a chart that will change based on the value changing from the dropdown. All of the informatin will be coming from one sheet.

Creating a chart with dynamic data

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.