Question

Hello I just need make a review for my work, and I think I did something wrong with the chart, can someone help?

Project Description: You work for a design firm that uses many of the software applications in the Adobe Creative Suite, especially Photoshop, Illustrator, InDesign, and Dreamweaver. Your boss has asked you to evaluate whether it would be worthwhile to upgrade the software to the latest version. In addition to reviewing any new or revised features, you also want to provide an analysis on any improvements in product efficiency and performance. You have the data, now you just need to analyze it. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Open TIA_Ch4_Start and save as TIA_Ch4_LastFirst. Type Current Average in cell F1, and type New Average in cell J1. In cell F2, use the AVERAGE function to compute the average of the range C2:E2. In cell J2, use the AVERAGE function to compute the average of the range G2:12. Select cell F2, then drag the Fill Handle to cell F13. Select cell J2, then drag the Fill Handle to cell J13. Select the cells in C2:J13, then format the cell contents with Number format with one decimal Select cell A2, and Merge and Center across cells A2:A5. Then adjust the orientation of the text to Rotate Text Up (90 degrees) (In Excel 2016 apply Rotate Text Up). Middle Align cell contents and Bold text. Use Format Painter to copy these formats to cell A6 and cell A10. Select range A2:J5, then apply Thick Box Border (In Excel 2016, apply Thick Outside Borders). Repeat with ranges A6:19 and A10:J13. Select range F1:F13, then apply Thick Box Border (In Excel 2016, apply Thick Outside Borders). Repeat with range J1:J13. Select J2:J13. Create a Conditional Format using the Less Than rule. In the Format cells that are LESS THAN box, enter =F2 (be sure to enter this as a relative reference). Set up the rule to format the cells with the fill color Green, Accent 6, Lighter 60% (tenth column, third row) and the font color Green, Accent 6, Darker 50%. Create a Clustered Bar Chart using ranges B1:B13, F1:F13, J1:J13. Modify the Clustered Bar Chart with a title Benchmark Comparison: New and Current Versions of CS Software and add a title to the Horizontal Axis that reads Seconds. Position and resize chart so it fits A16:J34. Save and close the workbook, and submit for grading

Answer 1

Hi,

All steps appears fine, however have few observation and suggestions :

Observations :

- Though current average and new average is selected, however structured bar seems to show only new average. The main importance is comparison & it seems that current average bar is not getting displayed

Recommendation :

- Column A1:A13 can be included in chart so that chart would incorporate major bifurcation as well

- As observed earlier, the current average bar display needs to be enabled so that comparison between current average and new average appears and help in decision making