| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Drop Lines
Hi, I have a simple 2-D Line Chart, whose X-Axis, plots 52 points for each Calendar Year (1 per week). Is it possible, to place a Drop Line (or something, similar) on Point 52 (and multiples, thereof), to separate each year? If so, how? Regards, Mick2 -- mick2 ------------------------------------------------------------------------ mick2's Profile: http://www.excelforum.com/member.php...o&userid=24143 View this thread: http://www.excelforum.com/showthread...hreadid=500522 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Drop Lines
Hi,
You could use error bars for the dropdowns. Add a column of data that contains the same Y value for any points you want to have a dropdown. Then double click the line series and on the Y Error bars set the Custom - range to this new data. Cheers Andy mick2 wrote: Hi, I have a simple 2-D Line Chart, whose X-Axis, plots 52 points for each Calendar Year (1 per week). Is it possible, to place a Drop Line (or something, similar) on Point 52 (and multiples, thereof), to separate each year? If so, how? Regards, Mick2 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Drop Lines
Thanks Andy. Mick2 -- mick2 ------------------------------------------------------------------------ mick2's Profile: http://www.excelforum.com/member.php...o&userid=24143 View this thread: http://www.excelforum.com/showthread...hreadid=500522 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Drop Lines
Thanks Andy, Your suggestion, did precisely what I wanted it to do. Bonzer! Regards, Mick. -- mick2 ------------------------------------------------------------------------ mick2's Profile: http://www.excelforum.com/member.php...o&userid=24143 View this thread: http://www.excelforum.com/showthread...hreadid=500522 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting unused lines between used lines? | Setting up and Configuration of Excel | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| restricting the drop lines to only a single series | Charts and Charting in Excel | |||
| Add drop lines at plot crossovers, swapping X and Y axis | Excel Discussion (Misc queries) | |||
| How do I print combo box drop down lines? | Excel Discussion (Misc queries) | |||
Linear Mode
