View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default putting in threshold line that easily depicts reaching a goal

Hi,

Examples of this can be found
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

KS wrote:
Using Excel 2003.
I have all my data for the month, but I need a highlighted vertical line
that shows our dept. has reached our goal, such as 20% of all sales must be
new accounts. That 20% line is the threshold/goal (or data series line,
unsure). My chart has the bars for all sales and percent of sales that are
new accounts. How do I display this line in a chart so that we may see our
efforts at a glance?