Currently use XY Scatter Charts to plot data with 401 or more points. When I
take each curve and add markers to it, so many data markers show up that it
obliterates the curve and makes it hard to tell where the true curve is. I
have tried making them smaller but by the time you make them small enough
they become hard to recognize within the line itself.
Is there any way to limit the number of data markers? Something that allows
me to put a data marker every 10th, 100th, etc point?
Jon Peltier - 27 Nov 2006 21:52 GMT
From the Excel Charting FAQ:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon024
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
> Currently use XY Scatter Charts to plot data with 401 or more points. When
> I
[quoted text clipped - 7 lines]
> allows
> me to put a data marker every 10th, 100th, etc point?