<div class="xblock xblock-public_view xblock-public_view-vertical" data-init="VerticalStudentView" data-runtime-class="LmsRuntime" data-request-token="e75987ce15c111ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@vertical+block@ad1337d9e0464d59be1f82034cbae045" data-block-type="vertical">
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@fc91dd497bc747778212fa2e7f5fc5e9">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-init="XBlockToXModuleShim" data-runtime-class="LmsRuntime" data-request-token="e75987ce15c111ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@fc91dd497bc747778212fa2e7f5fc5e9" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<p style="text-align: justify;">- Understand the uses of different types of chart: column chart, bar chart, line chart, pie chart</p>
<ul style="text-align: justify;">
<ul>
<li>Data which has been arranged in columns or rows on a worksheet can be plotted in a column chart. A column chart usually displays categories along the horizontal (category) axis and values along the vertical (value) axis</li>
<li>Line charts are typically used to plot changes in data over a period of time. It consists of a vertical and horizontal axis with plot points connected with lines indicating changes</li>
<li>Bar charts are similar to column charts but with horizontal bars instead of vertical</li>
<li>Pie charts are circular graphs that are broken into segments, and are excellent for displaying data as a percentage of the whole</li>
</ul>
</ul>
<p style="text-align: justify;">- Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart</p>
<ul>
<ul>
<li style="text-align: justify;">Select the data on the spreadsheet</li>
<li style="text-align: justify;">On the Insert tab, in the Charts group, click the chart button required</li>
<li style="text-align: justify;">Click the specific chart type required</li>
<li style="text-align: justify;">The chart will appear on the spreadsheet</li>
</ul>
</ul>
</div>
</div>
</div>
</div>
<div class="xblock xblock-public_view xblock-public_view-vertical" data-init="VerticalStudentView" data-runtime-class="LmsRuntime" data-request-token="e75987ce15c111ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@vertical+block@1985616f41a84268be8a031f26aa32b9" data-block-type="vertical">
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@36e895a2a7b7482c8cb77691d4ecd210">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-init="XBlockToXModuleShim" data-runtime-class="LmsRuntime" data-request-token="e75987ce15c111ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@36e895a2a7b7482c8cb77691d4ecd210" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<p>- <strong>Select</strong> a chart</p>
<ul>
<ul>
<li>Click the chart</li>
</ul>
</ul>
<p>- <strong>Change</strong> the chart <strong>type</strong></p>
<ul>
<ul>
<li>Select the chart</li>
<li>On the Design tab, in the Type group, click the Change Chart Type button</li>
<li>Click a chart type from the available list.</li>
<li>Click OK</li>
</ul>
</ul>
<p>- <strong>Move</strong> a chart</p>
<ul>
<ul>
<li>Select the chart</li>
<li>To move the chart within the worksheet, drag it to the location required</li>
<li>To move the chart within the worksheet, on the Design tab, in the Location group, click the Move Chart button</li>
<li>Check the New sheet: checkbox or check the Object in: checkbox and click the sheet required</li>
<li>Click OK</li>
<li>Drag the chart to the location required</li>
</ul>
</ul>
<p>- <strong>Resize</strong> a chart</p>
<ul>
<ul>
<li>Select the chart</li>
<li>Drag the chart’s sizing handles to the required size</li>
</ul>
</ul>
<p>- <strong>Delete</strong> a chart</p>
<ul>
<ul>
<li>Select the chart</li>
<li>Press the Delete key</li>
</ul>
</ul>
</div>
</div>
</div>
</div>
<div class="xblock xblock-public_view xblock-public_view-vertical" data-init="VerticalStudentView" data-runtime-class="LmsRuntime" data-request-token="e75987ce15c111ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@vertical+block@b4a60f31412f459bbbbf3a8934fceada" data-block-type="vertical">
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@8d269ced3d864eae9c922131ffaa61ca">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-init="XBlockToXModuleShim" data-runtime-class="LmsRuntime" data-request-token="e75987ce15c111ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@8d269ced3d864eae9c922131ffaa61ca" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<p>- <strong>Add a chart title</strong></p>
<ul>
<ul>
<li>Select the chart</li>
<li>On the Design tab, in the Chart Layouts group, click the Add Chart Element button</li>
<li>Select Chart Title</li>
<li>Click Above Chart or Centered Overlay</li>
<li>Enter the title required in the box that opens on the chart</li>
</ul>
</ul>
<p>- <strong>Remove a chart title</strong></p>
<ul>
<ul>
<li>Select the chart title</li>
<li>Press the Delete key</li>
</ul>
</ul>
<p>- <strong>Edit a chart title</strong></p>
<ul>
<ul>
<li>Select the chart title and edit as required</li>
</ul>
</ul>
<p>- <strong>Add, remove a chart legend</strong></p>
<ul>
<ul>
<li>Select the chart and click the Add Chart Element button</li>
<li>Select Legend</li>
<li>Click the location required for the data labels</li>
<li>Select None, Right, Top, Bottom as appropriate</li>
</ul>
</ul>
<p></p>
</div>
</div>
</div>
</div>
<div class="xblock xblock-public_view xblock-public_view-vertical" data-init="VerticalStudentView" data-runtime-class="LmsRuntime" data-request-token="e75987ce15c111ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@vertical+block@edc2d5d08ff745f2af0838a36ee3efad" data-block-type="vertical">
<div class="vert-mod">
<div class="vert vert-0" data-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@474eeb3c7aee404a84ebc5cedc2e529d">
<div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlBlock" data-init="XBlockToXModuleShim" data-runtime-class="LmsRuntime" data-request-token="e75987ce15c111ef881b0242c0a8281a" data-has-score="False" data-runtime-version="1" data-course-id="course-v1:ICON_WOMEN+ICW_BC_EN+2021" data-graded="False" data-usage-id="block-v1:ICON_WOMEN+ICW_BC_EN+2021+type@html+block@474eeb3c7aee404a84ebc5cedc2e529d" data-block-type="html">
<script type="json/xblock-args" class="xblock-json-init-args">
{"xmodule-type": "HTMLModule"}
</script>
<p>- <strong>Add, remove data labels</strong> in a chart: values/numbers, percentages</p>
<ul>
<ul>
<li>Select the chart</li>
<li>On the Design tab, in the Chart Layouts group, click the Add Chart Element button</li>
<li>Select Data Labels</li>
<li>Click the location required for the data labels</li>
<li>To remove data labels, deselect the Data Labels checkbox</li>
</ul>
</ul>
<p>- <strong>Change</strong> chart area background <strong>colour</strong>, legend fill colour</p>
<ul>
<ul>
<li>Select the chart background or the legend to change</li>
<li>On the Format tab, in the Current Selection group, click the Format Selection button</li>
<li>Click Fill</li>
<li>Click the Color button</li>
<li>Click the colour required</li>
</ul>
</ul>
<p>- <strong>Change the column, bar, line, pie slice colours in the chart</strong></p>
<ul>
<ul>
<li>Click the column, bar, line or pie slice of the chart to change</li>
<li>On the Format tab, in the Shape Styles group, click the Shape Fill button</li>
<li>Click the colour required</li>
</ul>
</ul>
<p>- <strong>Change font size and colour</strong> of chart title, chart axes, chart legend text</p>
<ul>
<ul>
<li>Select the chart title, chart axes or chart legend text to change</li>
<li>On the Home tab, in the font group, click the Font Size or Font Colour buttons</li>
<li>Click the font size or font colour required</li>
</ul>
</ul>
</div>
</div>
</div>
</div>