How to Apply Uniform Size to Multiple Charts?

« Convert an Excel Chart into a .GIF File

Jun 21

How to Apply Uniform Size to Multiple Charts?

Hi there,

Heyyy!!! weekend is finally here. Hope most of them are going for one day trips, right? A worse incidence happened in Andhra Pradesh, India in recent days. Almost 27 college students drowned in Himachal Pradesh due to opening of WATER DAM gates with out following any guidelines.

I think most of you all know this sad incidence, right?. All tourist lovers (Myself as well) on this behalf, I would like to say is be aware when you are entering into water. Even if we come across such situations please be dare enough not to scare in the water because water will not make you drown initially however because of our fear we will not concentrate what is going to be happen and we will drown.

Why I am saying this because I have trained swimming to few of them in my village. That's the reason why I am motivating you not to get fear when entering into water. Especially flowing water. Like swimming pools or we villagers trained in wells and training in wells motivate them not to fear in the water, rather just try not to move atleast so that some one will push you to the safe place.

Any how, sorry to those young students, let us move on to the topic now.

APPLYING A UNIFORM FORMAT TO CHARTS:

...

In this post, we will learn about how to apply uniform size to multiple charts for a data (same or different). In this example, we have "Monthly Paper Book Sales" for Excel, Word and Access.

Now, apply the charts using "Recommended Charts" in Charts Group. Here I am referring to Excel Version 2013. If you are not reached to this version, nothing to worry just select the appropriate charts that you like, for that matter.

Say you have to create three charts. (per this example here).

To align all these charts to the same size just select

DRAWING TOOLS -->FORMAT -->SIZE

Path to use for changing the chart height and width

Adjust the size depends on the space you have.

Now the charts are aligned in a vertical order (in Excel)

That's it Magic works !!!

USE CTRL KEY TO MOVE THE CHART:

In addition, to align the charts one below the other, hold CTRL button and select the chart object. Now, move the chart(s) using arrows. This moves chart by one pixel at a time.

This works well rather dragging and adjusting one below the other.

That's all from my end for today. Have a great Holiday.... :)

Download working file.xls from here.

REGISTER here to get the video explained about this post.

DID YOU WORK ON DRAWING TOOLS?

If you have worked on Drawing Tools Ribbon, please share your experience and thoughts about this post using below comments section.

If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog.

If you want to support me for maintaining this blog, REGISTER here for free and can receive all latest updates from "exceltoxl"

SOME IMPORTANT LINKS: