How to make square/equal grid in Excel Chart?

[lamyuwang]

As stated, How to make square/equal grid in Excel Chart?

I found that is really difficult to do so, as it is not an auto function.

Does any one of you could tell me how to do it?~~

if possible I want it workable in Excel 2000 or 2003.

Thanks a lot

 

[SkipVought]

Hi,

You must understand the elements of a chart.

1. The gridline incriments can be modified nearly an infinite number of ways, when the axis is numeric

2. A category axis has a fixed number of major and minor gridlines, base on the number of major elements and groups.

3. the SHAPE of the chart can affect the geometry: a TALL skinny chart or a SHORT fat chart, changes the way the gridlines appear.

BOTTOM LINE: I don't believe there's any way to CALCULATE "square" gridlines. YOU will have to play with the elements that YOU have and eyeball it best YOU can.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[JPaules]

You have to do it manually. For a little help:

http://www.mrexcel.com/tip071.shtml

--
JP