bar chart with threshold
 

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

bar chart with threshold
 

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)


"john" wrote:

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

bar chart with threshold
 

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?

"john" wrote:

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)


"john" wrote:

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

bar chart with threshold
 

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)


"john" wrote:

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?

"john" wrote:

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)


"john" wrote:

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

bar chart with threshold
 

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"john" wrote in message
...
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