Create and export charts in Excel to display your data visually

Generally in this application we work with numerical data and formulas that form a fundamental part of the spreadsheets created here. In this way, the program that belongs to the Office suite offers us everything we need to be able to work and manage these in the best way. In addition to all the formulas that it presents to us, it has a more than adequate user interface so that we can handle this information in the best way.

The Excel interface has cells that we can configure and customize independently depending on their use. But this is not the only thing we can handle here, since it also allows us to include other elements such as pictures or graphics that were from our sheet a much more visual and useful project.

Create Charts in Excel

Precisely for all this, below we will show you the best way to create your own charts in Excel. At the same time and if necessary, we will also show you how to export them directly from the Microsoft program. For this, the first thing we do is work with our spreadsheet in a conventional way. With this, what we want to tell you is that we must enter the corresponding numerical data and necessary formulas that will be part of the aforementioned sheet.

But it may be the case that we want to show these results in a more visual way so facilitate the interpretation of the project. This is where the graphics we refer to in these lines come into play. Next, we just have to mark with the mouse the range of data with which we want to work. These will be part of the graph that we want to design. Now we only have specify the type and format of this that we want to use depending on the amount and type of data selected. To do this, we go to the Insert menu option and take a look at the section Graphics.

In the first place, here we find a button that gives us access to the type of graphs recommended by the program based on the marked data. At the same time we can also open some of the lists belonging to other graphics designs to select the one that most interests us in each case. Once we have decided on a specific format, we click on it so that Excel itself creates the content we are looking for automatically.

From there we will be able to customize the size of the graph, modify it, add the legendscontrol the data to be displayed, their colors, etc. In short, the program presents us with all the necessary functions so that we can customize this element.

excel chart

Export charts in spreadsheet program

Once we have finished the design process of these elements, we may be interested in exporting them in order to use them in some other application. At this point, the truth is that Excel makes it very easy for us. all we have to do is go to the Start menu and select the option Save as.

However, here instead of using the usual and default format of Excel, we save the project in a file with .HTML format. In this way, what we achieve is that the application generates a file of these characteristics in which it includes all the graphics that we have added to the current spreadsheet. This will be of great help to us, for example, if we wish to share these results over the internet on a website.

Related Articles

Leave a Reply

Your email address will not be published.