respect proportions of x and y axis
 

I want to create a (bubble) chart that looks square.
I gave the same max and min value to x and y axis, but by default the chart
area is set in a rectangular shape.
How can I make the chart area square, having also a plot area with a square
shape ?
Thanks
Enzo

Hi,

Click on any spot in the the chart area; you will see that 'handles' (tiny
solid squares) are created at the corners and the midpoint of each side of
the rectangular chart area. Move the cursor to one of them (preferably a
midpoint); the cursor will change into a tiny double-headed arrow. Resize
the rectangle into a square (by holding the left-side mouse-button and moving
the cursor appropriately).

You can similarly change the aspect ratio of the plot area, by clicking on a
spot in the plot area and following the same steps as above.

Regards,
B. R. Ramachandran

"Enzo" wrote:

I want to create a (bubble) chart that looks square.
I gave the same max and min value to x and y axis, but by default the chart
area is set in a rectangular shape.
How can I make the chart area square, having also a plot area with a square
shape ?
Thanks
Enzo

Thanks, but the only thing I can change is the shape of the plot area. When I
select the chart area and move the cursor on its handles it does not change
to the double-headed arrow that allows re-shaping.
Rgds
Enzo

"B. R.Ramachandran" wrote:

Hi,

Click on any spot in the the chart area; you will see that 'handles' (tiny
solid squares) are created at the corners and the midpoint of each side of
the rectangular chart area. Move the cursor to one of them (preferably a
midpoint); the cursor will change into a tiny double-headed arrow. Resize
the rectangle into a square (by holding the left-side mouse-button and moving
the cursor appropriately).

You can similarly change the aspect ratio of the plot area, by clicking on a
spot in the plot area and following the same steps as above.

Regards,
B. R. Ramachandran

"Enzo" wrote:

I want to create a (bubble) chart that looks square.
I gave the same max and min value to x and y axis, but by default the chart
area is set in a rectangular shape.
How can I make the chart area square, having also a plot area with a square
shape ?
Thanks
Enzo

perchance is your chart in its own tab? When a chart is its own tab,
the size/shape of the overall chart area is determined by the paper
size/margin size settings in the page setup dialog. In this case, you
create a square chart area by changing the paper size/margin settings
to create a square printing area.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=476237

respect proportions of x and y axis
 

It works!
Thanks
Enzo
"MrShorty" wrote:


perchance is your chart in its own tab? When a chart is its own tab,
the size/shape of the overall chart area is determined by the paper
size/margin size settings in the page setup dialog. In this case, you
create a square chart area by changing the paper size/margin settings
to create a square printing area.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=476237