Chart Axis Formatting

**p135** · 08-01-2010, 09:49 PM

Hi
Is there a way to format the axis of a chart so that the X axis only displays the x values of the starting and the end point of the data and so that the Y axis displays the 0 line in addition to the other tick marks.

I am hoping to incorporate this into VBA code format.
Thanks

**shg** · 08-02-2010, 12:19 AM

Welcome to the forum.

Set the min value and the major unit approriately.

**p135** · 08-02-2010, 08:29 PM

I can't do that in my case. The limits are pre determined by something else. I can't set the limits to what I want so that the Y 0 value will show.

Also, what about the X values? It has to only show the starting and endpoint X values. Therefore, only 2 X values should be shown. Can Excel do this?

**teylyn** · 08-02-2010, 08:34 PM

Maybe it's time for an example file. You have not even mentioned what chart type your are using.

The min and max values can easily be set with code, the values can be derived from the min and max of your dataset.

Post an example, otherwise, I'm afraid there will be too much back and forth with words only.

cheers

**p135** · 08-17-2010, 08:43 PM

Ok here's a picture:

http://i.imgur.com/oXPfL.jpg

The first picture is what Excel normally does when adding numbers to an axis. The bottom graph is what I want, which is to only have number labels on the start and end points.

**shg** · 08-17-2010, 08:48 PM

Set the min value and the major unit approriately.

Set the min value to 1, the max value to 511, and the major unit to 510.

**teylyn** · 08-18-2010, 06:19 AM

p135,

instead of using an external site, please upload your files with the forum tools into the forum. A lot of corporate firewalls prevent our members from accessing files on file-sharing sites.

cheers