Create and export charts in Excel to display your data visually

The popular program to create Excel spreadsheets from Microsoft , presents us with a huge amount of content with which we can work here. Among all these we find the graphs that will be of enormous help to us when it comes to displaying the data in a more visual way.

Generally in this application we work with numerical data and formulas that are 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.

Create and export charts in Excel to display your data visually

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 images or graphics that made our project much more visual and useful.

Create Charts in Excel

Precisely for all this, below we will show you the best way to create your own graphs in Excel . At the same time and if necessary, we will also show you how to export them directly from the Microsoft program. To do 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 to 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 to 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 Graphics section.

Excel insertar gráficos

First of all, 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 graphic 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 legends , control the data that will be displayed, its colors , etc. In short, the program presents us with all the necessary functions so that we can customize this element.

gráfico Excel

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 Save As option.

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 want to share these results through the internet on a website.