manualbas.blogg.se - Cara membuat grafik di word

Cara membuat grafik di word how to#
Cara membuat grafik di word download#

Cara membuat grafik di word how to#

In addition to chart types, you'll need to understand how to read a chart. They work best with large data sets, allowing you to see a variety of information at the same time. Surface charts allow you to display data across a 3D landscape. Each value is shown as a slice of the pie, so it's easy to see which values make up the percentage of a whole.īar charts work just like column charts, but they use horizontal rather than vertical bars.Īrea charts are similar to line charts, except the areas under the lines are filled in. Pie charts make it easy to compare proportions. The data points are connected with lines, making it easy to see whether values are increasing or decreasing over time. Line charts are ideal for showing trends.

They can work with many different types of data, but they're most frequently used for comparing information. Click the arrows to see some of the different types of charts available in Word.Ĭolumn charts use vertical bars to represent data. Word has a variety of chart types, each with its own advantages. To use charts effectively, you'll need to understand what makes each one unique.Ĭlick the arrows in the slideshow below to learn more about the types of charts in Word.

Cara membuat grafik di word download#

You can download it here for free.There are several types of charts to choose from. This is product which is giving you money now.

Go to Ribbon > Insert > Text Box and insert box in the chart to create some labels.

The BCG Matrix is almost ready but needs some more formatting. Change Axis value to 0,1 (also depends on yor market!) Right-click the Y-axis and go to Format Axis.

Gridlines > Primary Horizontal Gridlines > None.

Your bubble chart starts to look similar to the BCG Matrix.Ĭlick the chart. Click Values in reverse Order and change Axis Value to 1 (it depends on your market!). Right-click the X-axis and go to Format Axis. Let’s continue the formatting of the X Axis. Right-click X-axis values and choose Select Data. This is what the basic bubble chart looks like.įor further formatting, change the X-axis values. Go to Ribbon > Insert > Other Charts and click Bubble Chart. Market Share will be the bubble in the chart. Market Growth will be measured using the values of Y axis. To insert the BCG Matrix into Excel, select columns A, B and C for all products. To get relative market share, just divide the market share of your product by the market share of your largest competitor.

You need market growth, market share for all of your products and relative market share. Preparing Data to BCG Matrixįirst, you need some data. Assessing the evaluation of these indicators allows you to classify the product while highlighting the 4 roles of the product that goes, sells or produces. It is the basis for planning the strategic future of a company. On the BCG Matrix, the axes report market share (horizontal) and market growth (vertical). The BCG Matrix is a tool that shows the situation in a company compared to its biggest competitors. BCG stands for Boston Consulting Group this company created this chart for the first time. The BCG Matix is a chart that shows the potential of your company's products. In this tutorial, you will learn how to create a BCG Matrix in Excel. How to Make Boston BCG Matrix in Excel Details