| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can i make a squared chart area
Hi,
am drowing lorenz curve and i need to make the length of the X-Axis of my chart exactly equals the length of the Y-Axis. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how can i make a squared chart area
Hi,
To make sure the area is exactly equal will need a little VBA code. Select the chart and run this routine. Sub SquarePlotarea() With ActiveChart.PlotArea .Width = .Height If .Width < .Height Then .Height = .Width End With End Sub Cheers Andy squared chart area wrote: Hi, am drowing lorenz curve and i need to make the length of the X-Axis of my chart exactly equals the length of the Y-Axis. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's equation for R-Squared value given for chart trendlines? | Charts and Charting in Excel | |||
| Resize plot area in a chart area | Excel Discussion (Misc queries) | |||
| How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
| excel should make it easier to have a 1 to 1 plot area in chart | Charts and Charting in Excel | |||
| Resize chart area without resizing plot area | Charts and Charting in Excel | |||
Hybrid Mode
