Excel helps us through spreadsheets to create tables and act on them. We can even work in Excel from an iPhone or PC cell phone, to create graphs with data that we have previously created. In this way we will see the data created in a better way in the graphs. In fact, using these spreadsheets you can also create a dual axis chart in Excel.
These dual axis charts are beneficial when the numbers on your chart vary from series or when data types are mixed, they work for the combination of columns and lines. You can also use these graphs for income per month, thus organizing the information effectively. Even excel allows you to add or insert a legend to your charts. In this post you will learn how to insert all these functions in two-axis charts.
Insert a dual axis chart in Excel
Starting from some previous data in the spreadsheet you will be able to create two-axis graphs in Excel. Or you can also make a chart in Excel by taking data from multiple sheets. For this you select the data with different values; you click on insert and you go to the line graph insert area; This will bring up different 2D line options, here choose the one you want, click on the one you choose.
In this way you will see a blank box that would be the area of the blank graph; click on the graph and at the top in the graph tool, press the data selection.
So a window will appear on the left that says add to legend entry or series; click on add and a new window will appear to add the name of the series, that is, of the category; then you select the values of the series or category. So you can do it with all your categories.
In the same way you can add months, names and dates in the select data source box; In the edit section that is on the right hand side of the box, click, then choose everything that is in the cell according to the category, finally click on accept.
Add the second axis
To add the second axis, click on the series, then right click on the format of the second series, where the values are straight, so on the right side the data series format will be available, click on the series option the 3 bars and click on the series options on the secondary axis.
In this way, in the right area of your graph you will see a new vertical axis, which will correspond to the data of the second series created.
Change chart type
If you want to change the type of graph follow the next steps. In your chart, right-click on the series you want to modify, click on change series chart type and in the change chart type box; click the type of chart you want.
Also, if you want you can change or modify the size of a chart in Excel, to make it thinner or wider; you can even make it smaller or bigger. In this way, you can change its general appearance and thus create a graphic to your liking.
Include the legend in a dual axis chart in Excel
You can also add the chart legend by clicking on the chart and clicking the plus sign in the top right corner of the chart. Within the options select legend. Click on the triangle on the right, here you will be able to place where you want to insert the legend, or choose the position.
It is convenient to use the legend, since these will help you to know the color that coincides with the series it represents. Another powerful tool is that you can make any modifications like choosing the chart colors or layouts in chart tools.
Without a doubt, this tool that Excel provides us, such as graphs with two axes, is very useful, since they allow us to effectively manage our finances; and if you have a company you will be able to know the high and low income of your business. Now that you know this Excel tool, share it if it was useful to you.
