Change number of markers in a graph

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

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

Originally Posted by 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

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

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

but then how to change the legend entry? As in the original legend will be a line and the created series will be a marker. how to have the legend consistent with what is shown in the graph, i.e., marker and the line together.

Thanks
Waqas

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