| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Goal line?
I'm making a piece per month chart with a line chart. Say our goal every
month is 5000 pcs per month. How do I make a line and either make it larger (darker) or name it as our goal line to show if we are hitting our goal each month? -- TJH |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Goal line?
Hi,
You just need to add another series where each value is the required goal for that period. You can then format the line series as you wish. Cheers Andy TJH wrote: I'm making a piece per month chart with a line chart. Say our goal every month is 5000 pcs per month. How do I make a line and either make it larger (darker) or name it as our goal line to show if we are hitting our goal each month? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add a goal line to a stacked bar chart in excel? | Charts and Charting in Excel | |||
| How do I set a goal line in a bar graph? | Charts and Charting in Excel | |||
| 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
