Progress YTD

[Guest]

I can chart sales numbers for different offices for different products, but I
want to add a line that will show progress toward goal. How do I accomplish
this.

 

[Debra Dalgleish]

Jon Peltier has instructions for adding a horizontal line to a chart:

http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine