I'll be teaching you how to create a Chart in MS Excel.
📒This section explains how to embed a chart into a worksheet using the chart wizard. An embedded chart is placed over-----not entered into------a cell range. All of the customizing and formatting for embedded charts is the same as for charts sheets. However, the methods for creating and printing the charts differ from the previous sections. To create an embedded chart, you select the cell range that you want to plot and then choose the insert chart, on this sheet command or click the chart wizard button. Either way, you must drag the cross-hair mouse pointer over an area on the worksheet to place the chart.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📒Area Chart:➜ Depicts the magnitude of change over a period.
📒Bar Chart: ➜is used to represent comparisons between items of a group.
📒Column Chart: ➜is used to display the change in data over a period and compare the items in a group, in column chart the months are displayed horizontally on the x-axis while the values of the items are displayed vertically on the y-axis.
📒Doughnut Chart:➜ This is similar to that of pie chart just that with this chart, it helps you to plot multitude data series in a single chart while a pie chart enables you plot only a singular data series.
📒Pie Chart:➜ It is a circular chart that is used to display the percentage contribution of item(s) in the selscted data series.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
📒Chart Sheet:➜ a worksheet that contains only a chart. If you want to create an embedded chart in a worksheet that also contains other items, such as cells or other controls, create a Chart instead. A Chart Sheet provides all the chart-related features of a native Microsoft.
📒Chart Objects:➜ The Chart Objects collection contains all the embedded charts on a single sheet.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ Subscribe! ➜ [ Ссылка ]
🔔 Click On The Bell + Turn On Notifications.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⌛TIMESTAMPS⏳
00:00 Intro
00:21 WORKING WITH CHARTS AND GRAPHICS
00:26 what is a chart in excel
01:06 Types of Charts
03:43 Entering labels and values
05:04 Adjusting the column width
06:33 Enhancing the appearance of the labels and values
08:18 borders
09:21 Creating a chart
11:54 Chart title
13:14 Enhancing your chart with colours
14:55 Switching from chart object to chart sheet
16:01 Changing a chart layout
17:15 Switching from chart sheet to chart object
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
►IF Function, Another Example | Excel Tutorial#19➜ [ Ссылка ]
►Introduction to Using The IF Function in Excel➜ [ Ссылка ]
►Using the financial function to calculate Between a Choice (FV)➜ [ Ссылка ]
►Using the financial function to calculate for a car loan with PMT➜[ Ссылка ]
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🌍 Website ➜ [ Ссылка ]
🌍? Download some questions & try your hands on➜ [ Ссылка ]
#armstrongcomputers
#exceltutorial
Enjoy the tutorial
