Understanding Charts: Column, Line, Pie, and Bar

• Charts are essential tools for presenting information graphically, making it easier to interpret and understand.

Column Charts

• Column charts are used to compare information.
• Uses vertical bars to present data.

Line Charts

• Line charts visualize how a set of values increases or decreases over time.
• It's ideal for showing patterns or data trends in values.

Pie Charts

• Pie charts display the percentage of values that make up a whole.
• Each value is represented as a slice of the pie.

Bar Charts

• Bar charts are used to compare information, similarly to column charts.
• This chart uses horizontal bars to represent data.

Chart Insertion

• To insert a chart:
• Go to the Insert tab on the ribbon.
• Choose the Chart button in the Illustrations group.
• An Insert Chart dialog box will appear, allowing the selection of the appropriate chart type for the data.
• Select OK.
• A chart and a worksheet will appear.
• The worksheet is where the data for the chart is to be entered.
• Input the necessary data into the worksheet.
• To complete, click the "Close" button on the worksheet.
• The completed chart will then appear in the document, where the chart title can also be edited.
• The Edit Data button on the Chart Tools Contextual Design tab allows you to edit the chart data.

Table Insertion

• To insert a table:
• Select the Insert tab on the Ribbon.
• Select the Table button from the Tables group.
• A grid of squares will appear, allowing the selection of the number of rows and columns by hovering the mouse and then clicking.
• Choose the Insert Table option to input the desired number of columns and rows in the Insert Table dialog box.
• Select the OK button.
• The table will appear in the document.
• Input the data into the table.

Design Groups

• The Table Tools Contextual Design tab has three groups:
• Table Style Options group
• Table Styles group
• Borders group

Layout Groups

• The Table Tools Contextual Layout tab has seven groups:
• Table group: used to select the current cell, row, column, or the entire table and to show/hide gridlines; the Table Properties dialog box can also be displayed here.
• Draw group: it is used to design tables by drawing cell, row, and column borders, or removing borders to create merged cells.
• Rows & Columns group: this is used to insert or delete rows and columns in the table.
• Merge group: creates different layouts than the default row and column appearance, and this merges and splits cells or tables.
• Cell Size group: changes row height and column width, plus, selecting AutoFit adjusts column widths based on text inside.
• Alignment group: it is used to change cell alignment, text direction, as well as cell margins, and spacing..
• Data group: it is used to arrange data in alphabetical or numerical order, convert tables to regular text, as well as add formulas to perform simple calculations.