| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Time line in excel graph
I need a vertical line in my graph to show that the graph information after
the line is the future predicted outcomes. I've tried countless different options and cant seem to find how to do this! |
|
#2
|
|||
|
|||
|
Hi,
There are various ways of addressing this problem. See the following for examples of adding lines to charts. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm Cheers Andy Wilkesy50 wrote: I need a vertical line in my graph to show that the graph information after the line is the future predicted outcomes. I've tried countless different options and cant seem to find how to do this! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
That's great Andy, Thanks. BUT it's a bit complicated for me to follow! Is
there anywhere where I can find an 'idiots guide'? Many Thanks, Nicole "Andy Pope" wrote: Hi, There are various ways of addressing this problem. See the following for examples of adding lines to charts. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm Cheers Andy Wilkesy50 wrote: I need a vertical line in my graph to show that the graph information after the line is the future predicted outcomes. I've tried countless different options and cant seem to find how to do this! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
|
|||
|
|||
|
Hi,
Ok lets start with what type of chart and data do you currently have? Cheers Andy Wilkesy50 wrote: That's great Andy, Thanks. BUT it's a bit complicated for me to follow! Is there anywhere where I can find an 'idiots guide'? Many Thanks, Nicole "Andy Pope" wrote: Hi, There are various ways of addressing this problem. See the following for examples of adding lines to charts. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm Cheers Andy Wilkesy50 wrote: I need a vertical line in my graph to show that the graph information after the line is the future predicted outcomes. I've tried countless different options and cant seem to find how to do this! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
|
|||
|
|||
|
It is a line chart. Across the bottom are some dates (random months...well I
tried to have random months like in my original chart, but I couldnt get that so it's periods of three months). Up the side are total point numbers. The series line charts the total point numbers, and at a certain point i need a line to signify the present, and then afterwards predicted results. "Andy Pope" wrote: Hi, Ok lets start with what type of chart and data do you currently have? Cheers Andy Wilkesy50 wrote: That's great Andy, Thanks. BUT it's a bit complicated for me to follow! Is there anywhere where I can find an 'idiots guide'? Many Thanks, Nicole "Andy Pope" wrote: Hi, There are various ways of addressing this problem. See the following for examples of adding lines to charts. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm Cheers Andy Wilkesy50 wrote: I need a vertical line in my graph to show that the graph information after the line is the future predicted outcomes. I've tried countless different options and cant seem to find how to do this! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
|
|||
|
|||
|
Hopefully this quick example will help with the datum line and your
other post regarding split series. http://www.andypope.info/ngs/ng38.htm Cheers Andy Wilkesy50 wrote: It is a line chart. Across the bottom are some dates (random months...well I tried to have random months like in my original chart, but I couldnt get that so it's periods of three months). Up the side are total point numbers. The series line charts the total point numbers, and at a certain point i need a line to signify the present, and then afterwards predicted results. "Andy Pope" wrote: Hi, Ok lets start with what type of chart and data do you currently have? Cheers Andy Wilkesy50 wrote: That's great Andy, Thanks. BUT it's a bit complicated for me to follow! Is there anywhere where I can find an 'idiots guide'? Many Thanks, Nicole "Andy Pope" wrote: Hi, There are various ways of addressing this problem. See the following for examples of adding lines to charts. http://peltiertech.com/Excel/Charts/AddLine.html http://tushar-mehta.com/excel/charts...nes/index.html http://www.andypope.info/charts/averageline.htm Cheers Andy Wilkesy50 wrote: I need a vertical line in my graph to show that the graph information after the line is the future predicted outcomes. I've tried countless different options and cant seem to find how to do this! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel sheet for workout jogging time and graph | New Users to Excel | |||
| How to remove an extra line added by excel when pasting into notep | Excel Discussion (Misc queries) | |||
| Line and Column Graph | Charts and Charting in Excel | |||
| Can you have a vertical line graph in Excel 2003 | Charts and Charting in Excel | |||
Linear Mode
