Creating a Diagram in MS Excel

Asked By yannie 0 points N/A Posted on - 04/09/2012

Good morning everyone, I am currently working on something in MS Excel. I wanted to create a diagram based on the data I imputed.

How will I do this? Anyone care to help me?

Thanks.

• Status: Open
• Question Views: 1203
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Tanok Bloran

Go To Solution

Best Answer

Best Answer

Answered By Tanok Bloran 80 points N/A #99325

Creating a Diagram in MS Excel

To create a diagram on MS Excel:

1. Make sure you already have an idea of what type of diagram you would like to use.

2. Once you already know what diagram to use, you may start creating it in Excel using Smart Art:

• Open MS Excel.
• Click Insert.
• Choose Smart Art.
• Choose the Smart Art type you would like to use which is found on the left sub menu.
• Choose the Smart Art icon you want.
• Type your text.
• Design your icon.
• Remove the grid lines by unselecting it under View.

Please note that you can’t save the diagram directly so once you remove the grid lines you can take a screen shot and edit this in paint or on any other image manipulation program you would like to save it.

To view the video tutorial in creating a diagram on MS Excel.

About Tanok Bloran

Questions
2

Answers
315

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 04/09/2012
• Question Category: MS Excel

Answered By theone1 0 points N/A #99326

Creating a Diagram in MS Excel

Hi,

The following are the steps to follow when making diagrams using excel. Highlight the data that you want may be a chat to be drawn. Do not include the title column of the data.

Go to insert and select chat. Click on the chat wizard. From the chart wizard you will be able to  see the following options:

• Column
• Bar
• Line
• Pie
• XY (Scatter
• Area
• Doughnut
• Radar
• Surface
• Bubble

From the above you may select what you want to insert. If for example you use pie  then hold down the mouse to see how the chart would look like. If not satisfied with the current type you still have the option of choosing next. If satisfied choose finish. The chart will have an option to specify the range of the data you want. When you are done you Go to the next step where by you put title to the chart.

Select next to be able to see how the chart would look like.

About theone1

Questions
0

Answers
40

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 05/19/2012
• Question Category: MS Excel