O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Plotting or Marking Every nth Point

Figure 26-5 shows a two-series line chart that has become difficult to read because the data points are too close together. (Each series now has 100 points; it's easy to imagine how much less effective this chart would become if its series grew to multiple hundreds of points.) Redrawing the series lines without markers wouldn't solve the problem in this hypothetical case; some points are required, but perhaps not all. One way around the difficulty is to plot only the points at some regular interval—every fifth point, for example. Another way is to plot all the points but suppress most of the markers.

The hundreds of markers in this line chart run together and make the chart difficult to read.

Figure 26-5. The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required