TASK 4 - You are a journalist analyzing the results of a recent election in your city. You've already created three charts. Perform the following tasks: Task Summary Required Actions Change the School Board President chart so it shows information about all three candidates. XCreate a new Clustered Column chart that shows all of the candidates and votes for the City Council B election. Position the new chart below the School Board President chart and to the left of the Mayor chart. Hide the legend of the City Council A chart. Apply the Style 3 style to the Mayor chart. In C22, use a function to return the highest number of votes received by any of the candidates.

TASK 4 - You are a journalist analyzing the results of a recent election in your city. You've already created three charts. Perform the following tasks: Task Summary Required Actions Change the School Board President chart so it shows information about all three candidates. XCreate a new Clustered Column chart that shows all of the candidates and votes for the City Council B election. Position the new chart below the School Board President chart and to the left of the Mayor chart. Hide the legend of the City Council A chart. Apply the Style 3 style to the Mayor chart. In C22, use a function to return the highest number of votes received by any of the candidates