I hate to tell you, that IS the easy way.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


retawol wrote:

> Thanks for your input, Gord.
> Unfortunately it doesn't seem to have any influence on the number of
> markers shown on my graph (btw. the option only appears for line style,
> not for x-y style).
>
> The work-around described by Jon obviersly works ( also thanks to you,
> Jon), but I still miss an easy way to control number of markers......
>
> For the time being I will go with Jon's idea.
>
> =) Retawol
>
>
> Gord Dibben Wrote:
>
>>Try right-clicking on the Axis and Format Axis>Scale.
>>
>>Set the number of points to be shown in "number of categories between
>>tick
>>mark labels" or "number of categories between tick marks".
>>
>>
>>Gord Dibben Excel MVP
>>
>>On Tue, 5 Jul 2005 07:55:29 -0500, retawol
>><retawol.1rp6qf_1120568798.2714@excelforum-nospam.com> wrote:
>>
>>
>>>Is it possible to control how many markers to show on a graph. For
>>>example in a graph with 500 points, I would like only to have a
>>
>>marker
>>
>>>for every 25 points, but I still want the graph to "line thorugh" all
>>>points. I know I can delete a marker by selecting it and press
>>
>>delete,
>>
>>>but with a lot of data point that is a lot of work....
>
>
>