Applications

How to easily resize or resize a chart in Excel

Many times our world can turn into complete chaos, when we don't know which option or function to use when we have a problem. The same happens to us in the Excel spreadsheet, even in its online version , when we've created a chart and don't know how to edit it. And in this article we will teach you how to easily change or modify the size of a chart in Excel.

If you didn't know, you can perfectly change or modify the total size of a chart, you can make it wider or thinner, bigger or smaller. Its general appearance can be changed and thus create an impressive design that everyone loves. You will see how simple it is and it will not take you long, because in a few steps it will be ready.

Our goal has always been and will always be that you know perfectly how to use the various office tools of Microsoft Office. And above all the correct use of Excel spreadsheet and the way in which the different graphics authorized by the application can be realized, as in the case of pie  in a cell.

How to easily resize or resize a chart in Excel

And let's start right away with the simple explanation of this procedure and learn to easily change or modify the size of a chart in Excel . To begin with, we are going to the application to open it and we will create a new book. In it you can create a chart, an advanced chart or if you have already created it, it only opens the book that you have already saved.

Now, having the graph on the sheet, we will click on it to select it and thus be able to change or modify the size . You will notice that the graph will be completely surrounded by a blue line, indicating that it has been selected for editing. Now the next step is to locate yourself in one of the corners or edges of the chart.

Three dots will be displayed and you will select, then the mouse pointer will turn into a double arrow. This will of course happen when you hover over a chart area that can be resized. To change the size, you need to click and drag inward or outward depending on whether you want to make it smaller or larger.

When you find the perfect size, you just need to release the mouse button, if you want to change it again, repeat the above steps again. And you can repeat this process as many times as you want until you are happy with the final size. And in this way, you have learned how to easily change or modify the size of a chart in Excel.

Different ways to easily resize or resize chart in Excel

There is another way to change or modify easily the size of a chart in Excel by entering the parameters of the graph and changing the width and height. To do this, you have to go to the graph and select it with the mouse by clicking. The next step is to review and select the Format option for the chart area.

Then you need to choose the Size and Properties option and here you can enter the data about the new height and width that the chart will have. And in this way, you could also  change or modify easily the size of a chart in Excel. It is also possible to do this if instead of having one chart you have more than one and want to resize them at the same time.

To begin with, we need to select all the graphics and we will do it with the left mouse button and at the same time you press the Ctrl key. Once selected, release the mouse and now position yourself on one of the graphs and right click. Then select the Size and properties option, enter the data for the new height and width.

As you can perfectly see, the size can be changed in different ways and they are all very easy to apply, but also if you want, you can  insert caption in a graph. And we come here with this article that you might learn how to easily change or modify the size of a chart in Excel.

Similar items

Leave your comment

Your email address will not be published. Required fields are marked with *

Button back to top