Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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.... |
#4
|
|||
|
|||
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.... |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of the series markers from yellow to Black | Charts and Charting in Excel | |||
how do i change the default number type which is formatted in new. | Excel Discussion (Misc queries) | |||
How do I change the category axis number formatting in a Pivot Ch. | Charts and Charting in Excel | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
how to change the h:mm format to number? | Excel Worksheet Functions |