How to Create a Chart in Excel
You want to Create a Chart in Excel? No problem! How to integrate a diagram is shown in my step by step guide. Whether controller, accountant or forwarder, who works with numbers needs a mature spreadsheet software. The best-known program in this sector is Excel. Even in schools, Excel is the most widely used software, at least in mathematics and science subjects.
How to Create a Chart in Excel
Income and expenses , sales, profit and loss or personal statistics, there is almost nothing that you can not capture and evaluate with Excel. Since the software is very complex, career starters should definitely take a basic course. For old hands , I recommend the nationwide offered Excel training by Medienreich to use. I myself have been working with Excel for years, but always discover new featuresthat make my day-to-day work easier.
One of the most common questions that I am asked about Excel is: How can I create a chart? In principle, this is easy to implement with Excel, but you also have to be careful, because a single wrong indication can distort the entire graphical evaluation.
Step 1 – Create a table
Actually, one can assume that there is already a table of usable data if you intend to create a diagram. If not, this is your first task. Please make sure that the respective columns get a corresponding headline. It is equally important that you format numbers as numbers (good instructions: here ). Otherwise it can happen that Excel can not render the diagram correctly.
Step 2 – Select diagram type
In order for Excel to be able to create a diagram, you must now mark the data that you want to use. This always makes sense if you only want to evaluate a part. If all data is to be used, it is sufficient if you click in any cell of your table.
Then move the mouse pointer into the menu bar and press “Paste”. In addition to graphics, various shapes and text fields, the “Diagram” option is now also available.
Excel offers a variety of different types. Whether it’s going to be a column chart, a pie chart or a line chart, decide for yourself. Do not worry, if you’ve decided on a chart type and you do not like it, you can easily undo it. But more on that later.
Step 3 – Integrate and position diagram
In my example, I opted for a column chart in 3D. One last click on the selected chart type and Excel immediately creates the finished graphical evaluation directly into our Excel folder. Do not be scared if the chart now obscures our spreadsheet. You can change the position as you like with a picture. To do this, click on the diagram, hold on and drag. For the moment of moving your diagram becomes transparent.
Extra tip: you do not like the selected shape? No problem: Click on your diagram and press the DEL key on your keyboard to delete it. However, you must start again with step 1.
Step 4 – Format Chart
If you are satisfied with your diagram, you can ignore step 4. For all others, there are now still small, but fine formatting options. First of all, you can not change the diagram type (line, column, bar) here, but you can still optically refine the selected shape.
In the menu bar you will find various styles after integrating the diagram.
Click on the small arrow and the complete selection opens.
Click on the desired selection and your diagram changes accordingly immediately. You can repeat this step as often as you like.
This step by step guide was created with Microsoft Excel 2010. The screenshots and steps may differ from other software versions.