Students create 3 different charts based on the information provided in the Data file EX 4-3. At least one chart should be a column chart; the additional charts can be any type. Charts should include enhancements, including titles, legends, value, and category axis titles, according to the suggestions in the table in step 5. Start Excel and download, save, and open the file EX 4-3.xlsx Download EX 4-3.xlsxFirst, preview the file then, click on the down arrow to download and save it in your Data Files using this naming convention Your Last name_Excel Final. EX 4-3.xlsx EX 4-3 Take some time to plan your charts. Consider which type of charts might best illustrate the information you need to display. What kind of chart enhancements do you want to use? Will a 3-D effect make your chart easier to understand? Create a Clustered Column chart for the data. (Go to Module 3: Unit 2 – More MS Excel More Quiz Tools to review Create a Clustered Column chart to learn how to create a Clustered Column chart.) Change at least one of the colors used in the data series. TitleText Chart TitleChicago Arts Alliance Events Vertical axis titleNumber of Events Horizontal axis titleTypes of EventsMake the appropriate modifications to the chart to make it visually attractive and easier to read and understand. Include a legend to the right of the chart, and add chart titles and horizontal and vertical axis using the text in the table on the right. Create two additional charts for the same data to show how different chart types display the same data. Reposition each new chart so that all charts are visible in the worksheet. One of the additional charts must be a pie chart (Go to Module 3: Unit 2 – More MS Excel More Quiz Tools to review Create a Pie chart to learn how to create a Pie chart.) Modify each new chart as necessary to improve its appearance and effectiveness.
