[Excel] I want to make an organizational diagram efficiently!Tech to create a conceptual diagram easily with Excel

huaweiwearabless 19/08/2022 718

How to use Excel that can't be heard anymore

「SmartArt」でサクッと組織図を作成する!

I was asked to create an unfamiliar organizational map ...!

At work, there are surprisingly many people who have been in trouble when asked to create conceptual diagrams such as business flow diagrams and organizational chart.With the function of "Smartart" in Excel, you can easily create such a conceptual diagram.

In this article, I will explain how to create the following organizational diagram (①) using Excel's "Smartart".

「SmartArt」を使って、次のような組織図(①)を作成

Let's make an organizational diagram using "Smartart"

Open the new sheet and click [Insert] tab (①) → [Figure] (②) → [Smartart] (③).

[挿入]タブ(①)→[図](②)→[SmartArt](③)をクリック

Select the Smartart Graphic dialog box is displayed.This dialog box allows you to select various types of conceptual diagrams.Here, select [Hierarchical structure] (④) from the left column of the dialog box, and select [Organizational diagram] (⑤) from the graphics (chart) displayed in the center column.

ダイアログボックスの左側の欄から[階層構造](④)を、中央の欄に表示されるグラフィック(図表)の中から[組織図](⑤)をそれぞれ選択

When you can select the chart to create, click [OK] (⑥) to close the dialog box.

【Excel】組織図を効率よく作りたい! エクセルで簡単に概念図を作成するテク

When you return to the sheet, an organization diagram (⑦) is inserted.On the left is a text window (⑧) for entering characters displayed in the figure.

組織図(⑦)が挿入されます。左側には、図形に表示する文字を入力するためのテキストウィンドウ(⑧)が表示される

Delete because there is an unnecessary figure in this inserted organizational map.Click on the border of ⑨ to select, and press the Delete key.

⑨の図形の枠線上をクリックして選択し、[Delete]キーを押す

Then, the shape selected earlier is deleted (⑩).

先ほど選択した図形が削除されます(⑩)

Let's enter characters in the figure.Click the input field displayed as [Text] at the top of the text window and enter "Sales Headquarters" (⑪).It is also displayed on the figure at the same time as the input (⑫).

[テキスト]と表示された入力欄をクリックして「営業本部」(⑪)と入力します。入力と同時に図形にも表示されます(⑫)

After the input, press the [↓] key (downward arrow key) to move to the next input field.

Similarly, we will enter the characters (Tokyo branch office, Nagoya branch office, Osaka branch office) in the following three shapes (⑬).

次の3つの図形に文字(東京支社、名古屋支社、大阪支社)を入力していきます(⑬)

If you can enter "Osaka Branch", press the [Enter] key.Then, a new figure is created in the same hierarchy, but press the [Tab] key here.Then, a figure is created in the hierarchy below the Osaka branch (⑭).

[Tab]キーを押します。すると、「大阪支社」の下の階層に図形が作成されます(⑭)

Enter the "Sales Division" (⑮) in the text window input field and press the [Enter] key.

テキストウィンドウの入力欄に「営業第一課」(⑮)と入力

Then, a new figure is added to the same hierarchy, so in the input field of the text window, enter "Sales 2" (⑯).

テキストウィンドウの入力欄に「営業第二課」(⑯)と入力

Since the shapes under the "Osaka branch office" are displayed up and down (⑰), change to the same arrangement as others.Select (⑱) the figure of the Osaka Branch and click the [Smartart Design] tab (⑲) → [Layout] (⑳) → [Standard] (㉑).

「大阪支社」の図形を選択(⑱)し、[SmartArtのデザイン]タブ(⑲)→[レイアウト](⑳)→[標準](㉑)をクリック

The arrangement of the shapes under the "Osaka branch office" has been changed (㉒).I was able to create an organizational map that was introduced at the beginning.

「大阪支社」配下の図形の配置が変更されました(㉒)

Efficiently create a conceptual diagram using "Smartart"

This time, I explained how to create an organizational diagram using Excel's "Smartart".It is finished in a more efficient and well -organized organizational diagram than creating a normal figure function.In addition, you can make various conceptual diagrams in "Smartart", so please try it.

[How to use Excel that can't be heard anymore]の他の記事を見る関連リンクGroup site links
  • Copyright © 2018IMPRESS CORPORATION.All Rights Reserved.