markethaa.blogg.se

Here we’ll give you the steps to make these exciting visualizations-but we also want to hear uses you have for them, so tell us in a comment below!

There is currently no specific built-in functionality for creating Reference Lines in Excel 2010, but there are still a few ways to add them to your chart. 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. Today’s blog post is brought to you by Cathy Harley a Program Manager on the Excel Chart team.