| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show a threshold line in an Excel chart? | Charts and Charting in Excel | |||
| Round to up to a threshold | Excel Worksheet Functions | |||
| Index Using Threshold Value | Excel Discussion (Misc queries) | |||
| Need to add a goal threshold | Excel Worksheet Functions | |||
| How do I sum numbers up to an certain threshold in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
