Change number of markers in a graph
 

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....


--
retawol
------------------------------------------------------------------------
retawol's Profile: http://www.excelforum.com/member.php...o&userid=24913
View this thread: http://www.excelforum.com/showthread...hreadid=384502

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.

"retawol" 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....


--
retawol
------------------------------------------------------------------------
retawol's Profile: http://www.excelforum.com/member.php...o&userid=24913
View this thread: http://www.excelforum.com/showthread...hreadid=384502

Try right-clicking on the Axis and Format AxisScale.

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
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....

The Charting FAQ explains how to do this:

http://pubs.logicalexpressions.com/P...?ID=209#jon024

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


retawol 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....

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 AxisScale.

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
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....


--
retawol
------------------------------------------------------------------------
retawol's Profile: http://www.excelforum.com/member.php...o&userid=24913
View this thread: http://www.excelforum.com/showthread...hreadid=384502

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 AxisScale.

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
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....