Excel Charts: How to Read Them and How to Build Them
Edward A Leshik, Jane Cralle · 2012
This chapter provides an overview of handling of charts in Excel. The knowledge of handling charts in Excel easily transfers to handling charts in the Order Management System and to specialist charting programs. Excel charts limit plots to 32 000 data points per chart, and safely up to six plots per chart. The chapter describes how to set up, modify, and generally use charts in Excel as this is one of the most important skills that makes the creation of algorithms, from the very basic to the very advanced, immeasurably faster and easier to deal with. A very useful feature in Excel charts is the ability to add “trend lines” to a curve and to also be able to call up the “fit” of the trend line for a number of common equations.