Change number of markers in a graph

[retawol]

Is it possible to control how many markers to show on a graph. Fo
example in a graph with 500 points, I would like only to have a marke
for every 25 points, but I still want the graph to "line thorugh" al
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...

 

[Guest]

The simplest way to do this is to copy your data show only every 25th point
and plot the reduced second set with symbols, and your original set with
lines only.

 

[Gord Dibben]

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

 

[Jon Peltier]

The Charting FAQ explains how to do this:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon024

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

 

[retawol]

Thanks for your input, Gord.
Unfortunately it doesn't seem to have any influence on the number o
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

 

[Jon Peltier]

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/
_______