How To Apply Uniform Size To All Charts In Microsoft Excel

Home  >>  Microsoft Excel  >>  How To Apply Uniform Size To All Charts In Microsoft Excel

How To Apply Uniform Size To All Charts In Microsoft Excel

When you make a diagram, Excel modifies the outline’s size, contingent upon space, marks, number of information focuses, et cetera. Along these lines, you should need to change the extent of each diagram so they’re all the same. There’s very little work to compelling a graph’s size sometime later, yet the assignment may wind up excess in the event that you have a few diagrams or in the event that you need to resize a couple of outlines regularly. Luckily, you can make a different determination and enter the fitting size measurements for the majority of the diagrams, on the double. We should outline this basic manual system on the graphs demonstrated as follows.


In the event that one of the outlines is about the correct size, select it and note its measurements by tapping the relevant Format tab. Exceed expectations will show the chose graph’s measurements in the Size gathering. In Excel 2003, right-tap the outline and pick Format Object.


To dole out a similar size measurements to the greater part of the diagrams in the meantime, do the accompanying:

  1. Select the greater part of the diagrams by holding down the [Shift] key as you click each graph to make a various choice.
  2. Tap the logical Format tab. In Excel 2003, right-tap the choice, and pick Format Object.
  3. Enter the fitting measurement esteems utilizing the Shape Height and Shape Width choices in the Size gathering.

install office

Exceed expectations allots the size settings to the greater part of the chose outlines, not only one. That way, you don’t need to rehash this specific undertaking a few times-once is sufficient! (To adjust the graphs, you can utilize the Align alternatives in the Arrange gathering.)

That was sufficiently simple, however in the event that you rehash this procedure frequently, you should need to utilize a full scale to robotize the procedure. The accompanying large scale resizes the majority of the diagrams on the dynamic sheet to two inches high and four inches wide (in respect to the printed page, not what you see on screen):

Sub ResizeCharts()

‘Make all diagrams on dynamic sheet uniform size.

Diminish cht As ChartObject

For Each cht In ActiveSheet.ChartObjects

cht.Height = Application.InchesToPoints(2)

cht.Width = Application.InchesToPoints(4)


End Sub

To enter this large scale, press [Alt]+[F11] to open the Visual Basic Editor (VBE). At that point, pick Module from the Insert menu and enter the large scale into the module.

The size settings are hard-coded, however you could upgrade the large scale to request both from the client. In case you’re more happy with working with centimeters, utilize the CentimetersToPoints technique rather than InchesToPoints. You could likewise supply the measurements in crude qualities, yet that is not as correct as utilizing one of the estimation change techniques. For example, two inches is around 144 focuses and four inches is 288. The equal explanations take after:

cht.Height = 144

cht.Width = 288

On the off chance that you don’t know how to change over crawls to focuses, utilize can utilize an online adding machine.

To run the full scale, come back to Excel and select the sheet with the graphs you need to resize. Tap the Develop tab and after that pick Macros in the Code gathering. Pick ResizeCharts() and snap Run. In Excel 2003, pick Macro from the Tools menu, and after that select Macros from the subsequent submenu. Pick ResizeCharts() and snap Run.

Keep in mind, this large scale works just on the dynamic sheet, not the whole exercise manual.

Blogs : setup

Leave a Reply

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