Activity 11.01 – Creating a chart (artist track sales)

The manager has changed their requirements for artists' tracklists. They now want a bar chart with artists' tracks and their sales. Fortunately, we can still use the dropdown to select an artist, and there is a view in the chinook database that will provide data, named vw_artist_track_sales.

Your task is to do the following:

1. Create a new function and name it ArtistTrackSales.
2. The function is to read the data from the MySQL view named vw_artist_track_sales, filter the data to the selected artist in the dropdown in P5, and place the data in the workbook named Data Sheet in columns L and M.
3. You need to then modify the existing worksheet_change event to call your new function to load the data.
4. Then, create a bar chart and place it beneath the dropdown, display the data generated from the function, name the chart chrtArtistTrackSales, and format the area around the chart on the dashboard to fit...