| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
putting in threshold line that easily depicts reaching a goal
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set a goal line in a bar graph? | Charts and Charting in Excel | |||
| Need to add a goal threshold | Excel Worksheet Functions | |||
| Goal Line in chart but not on data tabel | Charts and Charting in Excel | |||
| How do I create a goal line on a bar chart? | Charts and Charting in Excel | |||
| goal line in excel chart | Charts and Charting in Excel | |||
Linear Mode
