Question

Week 4 Discussion Board - Charts and Financial Data Using the Internet, conduct a thorough search for more information on using charts in Excel and discuss two for your response to my post. Choose a topic from the following: • Session 4.1 Create a pie chart • Format chart elements • Create a line chart • Work with chart legends • Create a combination chart • Session 4.2 • Create a scatter chart • Edit a chart data source • Create a data callout • Insert shapes and icons into a worksheet Create and edit a data bar Create and edit a group of sparklines

Answer 1

Introduction-

Pie charts are one of the most useful ways to depict your idea more simply and compactly. They would reflect the contribution of each factor in the whole.

How to create a Pie chart?

Step1 – Prepare the data on which you would apply the pie chart.

Gadgets Units Sold Mobile 1,453 PCS 4,359 Laptops 7,685 Tablets 10,000 3,452 Total 26,949 TVs

Step 2 – Select the table and Go to the Insert option to create a 2D pie chart or any other pie chart you want.

Auto Save @CH A S -B- Book1 - Excel Aditya Bhutra - X Data Review View Help GL Analyzer PDF-XChange Audit Tools Audit Enablers Tell me what you want to do Share Get Add-ins Get Add-ins Tol TT Equation - 22 Symbol S bal .. - Slicer Timeline My Add-ins ? .. Recommended_ Charts 2-D Pie Maps Pivotchart Link File Home Insert Page Layout Formulas Shapes LO L9 Icons PivotTable Recommended Table Pictures Online Pivot Tables Pictures Tables illustrations B2 - X fx Gadgets B C D E Text 3D Map Tours Line Column Wind Loss Sparklincs Add ins Filters Links Symbols F G H I L M N O P Q 3-D Pie Gadgets Units Sold Mobile 1,453 PCs 4,359 Laptops 7,685 Tablets 10,000 TVs 3,452 Total 26,949 Doughnut More Pie Charts... 20 21 22 Sheet2 Sheet1 Ready # E -- + 10095 Average: 0983 Count: 14 Sum:53899 R A e ale 0 e 9 D . . . ** ENG 01:59 28-01-2020

Step 3 – Once you click on the pie chart, the chart would pop up automatically with the desired formatting options.

AutoSave OS B Book1 - Excel Aditya Bhutra - O X PDF-XChange Audit Tools Audit Enablers Tell me what you want to do Share 2 O La Copy Fill 020 clear File Home Insert Page Layout Formulas Data Review View Help GL Analyzer X Cut Calibri - 11 -AA ===> Wrap Text Custom Paste Format Painter inter B I U. I. A Merge & Center - 0 % , Clipboard Font s Alignment Number - X V fix 3452 B C D E F G H I J Conditional Format as Cell Formatting Table - Styles - Styles Insert Delete Format - - - Colls Sort & Find & Filter - Select - Editing K L M N O P Q R S A Gadgets Units Sold Mobile 1,453 PCs 4,359 Laptops 7,685 Tablets 10,000 3,452 Units Sold TVs Chart Area Mobile PCS Laptops Tablets TVs 20 21 22 Sheet2 Sheet1 Ready # EE - + 100% 02-02 e ale 0 e 9 RAA D . . ENG 28-01-2020

Step 4- You can change the colour scheme, or the data, or the design of the chart, to make it look more discernible.

AutoSaveCH OS B : Book1 - Excel Chart Tools - O X Aditya Bhutra Format tell me File Home Insert Page Layout Formulas Data Review View Help GL Analyzer PDF-XChange Audit Tools Audit Enablers Design Share I Add Chart Quick Change Element - Layout - Colors Chart Layouts Chart 1 - X Switch Row/ Select Change Move Column Data Chart Type Chart Data Type Location Chart Styles fix B C D E F G H I J K L M N O P Q R S A Gadgets Mobile PCS Laptops Tablets TVS Units Sold 1,453 4,359 7,685 10,000 3,452 Units Sold Mobile PCS -Laptops Tablets TVs 20 21 22 Sheet2 Sheet1 Ready # EE - + 100% 02-02 e ale 0 e 9 RAA D . . ENG 28-01-2020

Create a Line Chart

Line charts are useful when we want to show the continuous flow of data over time, benchmarked against the common scale and is helpful when one wants to show the movement of data consistently.

How to create a line chart?

Step 1 – Select the data and go to Insert Option in the bar. Click on the Recommended Charts option.

Auto Save @CH A S -B- Book1 - Excel Aditya Bhutra - X Data Review View Help GL Analyzer PDF-XChange Audit Tools Audit Enablers Tell me what you want to do Share .. Get Add-ins My Add-ins TT Equation - 22 Symbol S bal File Home Insert Page Layout Formulas Shapes LO L9 Icons PivotTable Recommended Table Pictures Online Pivot Tables Pictures Tables illustrations B2 - X fx Gadgets - Slicer Timeline aps Pivotchart Link Text 3D Map Tours Line Column Wind Loss Sparklincs Add ins Filters Links Symbols Recommended Charts Charts Recommended Charts Want us to recommend a good chart to showcase your data? B C D E F G L M N O P Q R S A Gadgets Units Sold Mobile 1,453 PCs 4,359 Laptops 7,685 Tablets 10,000 TVs 3,452 Select data in your worksheet and click this button to get a customized set of charts that we think will fit best with your data. 20 21 22 Sheet2 Sheet1 Ready # E E -— + 1009 Average: 5389.8 Count: 12 Sum: 26949 R A e ale 0 e 9 D . . . ** ENG 02:17 28-01-2020

Step 2 – Go to All Charts tab and from there select the Line chart option. Select the best suitable line chart.

Auto Save CH 5. B : Book1 - Excel Aditya Bhutra - X File Home Insert Page Layout Formula: Insert Chart ? X ell me what you want to do Share Shap 0 Recommended Charts All Charts 9 TT Equation - 22 Symbol S bal Icons - Slicer Timeline Recent Link Text Pivot Table Recommended Table Pivot Tables Tables Pictures Online a. Pictures illustrations WWWWWW Links Symbols B2 - ft Gadgets Line D O P Q R S Gadgets Units Sold Mobile 1,453 PCs 4,359 Laptops 7,685 Tablets 10,000 TVs 3,452 Templates H Column A Line Pie Bar Area XY (Scatter) Map Hill Stock Surface Radar Treemap Sunburst Histogram 3:0 Box & Whisker Waterfall Tunnel Combo 20 21 22 OK Cancel Sheet2 Sheet1 Ready # E E + 1009 Average: 5289.8 Count: 12 Sum: 26949 R A e ale 0 e 9 D -— 02-18 ENG 28-01-2020 . . . **

Step 3- Finally the chart would appear on your screen and make whatever changes you want to make as per your specifications.

AutoSaveCH OS B : Book1 - Excel Chart Tools - X Aditya Bhutra Format tell me File Home Insert Page Layout Formulas Data Review View Help G L Analyzer PDF-XChange Audit Tools Audit Enablers Design Share Add Chart Quick Change Element - Layout - Colors Chart Layouts Switch Row/ Select Change Move Column Data Chart Type Chart Data Type Location Chart Styles Chart 3 - X fix A B C D E F G H I J K L M N O P Q R S A Gadgets Mobile PCS Laptops Tablets TVS Units Sold 1,453 4,359 7,685 10,000 3,452 Units Sold 12,000 10,000 2,000 Mobile PCS Laptops Tablets TVs 20 21 22 Sheet2 Sheet1 + Ready # E E -— + 100% Average: 5389.8 Count: 12 Sum: 26949 R A e ale 0 e 9 D . . . ** ENG 02-20 28-01-2020

Step 4 – From this, we can easily conclude the highest sales and the lowest sales of the gadgets.