macro to align a chart right

[#1]

how to align a chart right ,

how to set alignment of a chart.

[sunil2288]

Hi Rajani,

Which part of the chart u do want to allign.

If u want to allign Axis value then goto chart Properties-->Axes(tab)

In the Axes tab there is an Dimension option and there

1>Primary Dimension label

2>Secondary Dimension label.

You can allignit as Horizontal OR Vertical OR Slanting..

If any queries pls share it.

Thanks

Sunil

[#3]

Actually I want to align whole chart right

[#4]

Actually I want to align whole chart right

[sunil2288]

Hi Rajani,

In the sheet on the above there is a panel called Design ..In that panel a few allignment is present . You need to select the Object(Tables,Charts,List Boxes etc).Then allign it as needed.

Just try it out it will solve your problem.

Thanks

Sunil (Accept My friend Req)

[#6]

But this menu activate after selecting all objects of the sheet , how to align individual sheet

[sunil2288]

Hi,

You will allign a object always comparing to other object(s). Isn't it?

If so then select the objects that you want to allign by pressing Shift key and selecting the objects that you want to allign.

If you have any doubt please clarify.....

Thanks..

[#8]

Hi ,

When I select two objects , both aligns at right position, I want that one object at right and other at left correponding to screen

[sunil2288]

Hi Rajani,

Please don't get horrified..

You can do that allignment just try all of the possible combination of allignment ...

It will allign your objects as required...

Thanks.....