bar chart with threshold

J

john

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
 
J

john

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)
 
J

john

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?
 
J

john

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a sales commission formula 3
Bar Chart with Data Elements 1
sideways stacked bar charts with line series on the same axis 0
Threshold Line Across Chart 2
Thermometer chart with 2 Y axis? 3
Move bar chart to behind lines 0
Skinny bars? 0
Plotting Line Graphs to Specific Bar Graphs 0

Top