O'Reilly logo

Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond by Reinhold Scheck

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

XY (Scatter) Charts

In this chapter, you’ve already been provided with a lot of technical basic information. Therefore, I will discuss the scatter charts only briefly. In technical terms, this type largely corresponds to the line chart. With only one exception: the XY (Scatter) chart uses no category axis, but two value axes (one vertical and one horizontal) in its standard version. As for the other types, there can also be secondary axes in addition to the primary axes; in some exceptional cases such a chart can also have four value axes.

The position of the data point of a scatter chart is determined by the coordinate of two values (X and Y) and can therefore be displayed in any position of the plot area. Any linear sequence of the points created ...

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