Excel - Create a chart by selecting data from a column (automatically populated the chart)

Job ID: 34572095

Budget: $10 – $30 USD

The Excel sheet has 6 columns, every time a category is selected from an item, the chart is reflected automatically, and the new change appears on the chart. Need someone who knows very well excel.
Related categories: Visual Basic Data Processing Data Entry Excel VBScript