| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Chart scale-length help.
I have a made an x-y scatter chart in Excel but I want the x and y axis to be of the same scale-length. Is there anyway to do this besides fiddling with resizing manually? Thanks in advance. -- Vyz ------------------------------------------------------------------------ Vyz's Profile: http://www.excelforum.com/member.php...o&userid=25127 View this thread: http://www.excelforum.com/showthread...hreadid=386290 |
|
#2
|
|||
|
|||
|
Vyz,
Select the chart and run this macro. You can assign it to a keyboard shortcut, toolbar button, menu item. Sub SquarePlotArea() ActiveChart.PlotArea.Width = ActiveChart.PlotArea.Height End Sub -- Earl Kiosterud www.smokeylake.com "Vyz" wrote in message ... I have a made an x-y scatter chart in Excel but I want the x and y axis to be of the same scale-length. Is there anyway to do this besides fiddling with resizing manually? Thanks in advance. -- Vyz ------------------------------------------------------------------------ Vyz's Profile: http://www.excelforum.com/member.php...o&userid=25127 View this thread: http://www.excelforum.com/showthread...hreadid=386290 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart scale & paper size | New Users to Excel | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Chart with Colored Background - Log Log Scale | Charts and Charting in Excel | |||
| Cell value as chart scale maximum | Charts and Charting in Excel | |||
Hybrid Mode
