Have you ever wanted to add a horizontal or vertical line to your chart to indicate a key value, sales threshold, important date, or the average of your data? Are you looking to impress managers and convince clients with your superb charts? Reference Lines (see the dotted black line on the chart below) can be powerful tools in effectively communicating important points in your data. There is currently no specific built-in functionality for creating Reference Lines in Excel 2010, but there are still
Read More...
Read the complete post at http://blogs.office.com/b/microsoft-excel/archive/2011/07/21/create-convincing-visualizations-by-adding-reference-lines-to-your-excel-charts.aspx
Posted
Jul 21 2011, 10:58 PM
by
Excel Blog