This is a discussion on excel charts - I want markers to skip data points within the Excel Questions forums, part of the Question Forums category; I have charts with lots of data points (3,000). The markers to identify series all run together since the data ...
I have charts with lots of data points (3,000). The markers to identify series all run together since the data points are so close together. Is there a way to have the markers appear every 100 data points or so.
Similar problem with dashed lines. My dashed lines appear as solids because the data points are so close together.
Plot the few data points you want as markers as a 2nd series.
For the first series, show the line but no markers. For the 2nd series, show the markers but no line.
Tushar Mehta (Microsoft MVP Excel 2000-present)
Excel & PowerPoint tutorials and add-ins; custom productivity solutions for MS Office