Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |