Conditional Charts Formatting (4) Charts Manage allow conditional you to present formatting information contained in the One worksheet can create, in a graphic edit, delete, format. and Excel view offers all conditional many types formatting of charts rules including: in the Column, workbook Line, by Pie, using Bar, the Area, Conditional Scatter Formatting and more. Rules To view Manager the charts dialog available box. On the click Home the Insert tab, in Tab the on Styles the Ribbon. group, click the arrow next to Conditional Formatting, and then click Manage Rules. Against Show Formatting rule for, choose the worksheet whose rules you want to manipulate. All relevant rules for the worksheet are lists. These rules are evaluated in order of precedence by how they are listed in this dialog box Create a Chart To create a chart: Select the cells that contain the data you want to use in the chart Click the Insert tab on the Ribbon Click the type of Chart you want to create ©Digital Bridge Institute, Abuja Page Page 179 180 ©Digital Bridge Institute, Abuja
Conditional Formatting (4) Manage conditional formatting One can create, edit, delete, and view all conditional formatting rules in the workbook by using the Conditional Formatting Rules Manager dialog box. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Manage Rules. Against Show Formatting rule for, choose the worksheet whose rules you want to manipulate. All relevant rules for the worksheet are lists. These rules are evaluated in order of precedence by how they are listed in this dialog box ©Digital Bridge Institute, Abuja Page 179 Charts Charts allow you to present information contained in the worksheet in a graphic format. Excel offers many types of charts including: Column, Line, Pie, Bar, Area, Scatter and more. To view the charts available click the Insert Tab on the Ribbon. Create a Chart To create a chart: Select the cells that contain the data you want to use in the chart Click the Insert tab on the Ribbon Click the type of Chart you want to create ©Digital Bridge Institute, Abuja Page 180
Advance_Digital_Appreciation.docx