A target line works best when comparing an actual value to an ideal value such as a projection or a goal. Start with an Excel worksheet that includes two columns of data; for example, one column ...

In the Type group click Change Chart Type. In the resulting dialog, change the Target setting from Line to Stacked Line with Markers, as shown in Figure F, then click OK. Figure F ...

How to Add Zoom & Scroll to an Excel Chart. Excel charts containing large amounts of data prevent readers for easily reading small segments. For example, if a chart tracks your company's daily ...