Thursday, September 20, 2012

How to Create Target Lines in Excel Charts


1. Locate the chart data on your Excel worksheet. If you aren't sure which data was used for the chart, click once on the chart: the chart data will be bordered by a blue line on the worksheet.
2. Click on the first blank cell to the right of your chart data. If you don't have a blank column directly to the right of your chart data, create one: right click, then click 'Insert' and then click 'Entire column.'
3. Type your target. For example, if your graph consists of sales figures and your target sales goal is 20 units, type '20.'
4. Click the fill handle for the cell. The cell looks like a little black square at the bottom right of the cell. Drag it down the column to the last row in your chart data. This action copies the input for the cell (in this example, 20) to all cells in the column. This is the dummy series for your chart.
5. Highlight the entire chart data area, including the dummy series. To highlight the data, left click at the top left of the cells and then drag the cursor to the bottom right.
6. Click the 'Insert' tab. Select the chart type you want displayed. For example, click 'Column' and then click '2D.' Excel will insert the chart into the spreadsheet.
7. Click the dummy series on the chart, then click 'Change Chart Type.' Change the chart type to 'Line.'

Blogger news