bar chart with threshold

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to create a line that goes across the bar chart for acheivement
of quota for example I have 5 sales people each with a quota of 300000. how
do I put a line in so that the person who sells 400000 will still start from
o and goe through the 300000
 
Set up an extra column with 300000 and use this as another series of data for
the chart.
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
that just puts and extra column I wanted to have something going across the x
axis at the 300,000 is that possible without just drawing the line in?
 
Right click on the column and change chart type to a line
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Back
Top