| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control Z-Order of drop lines in an Excel 2007 chart?
Can anyone describe for me the procedure for changing/controlling the z-order
of drop lines relative to the plotted data in an Excel 2007 chart? I would like for the chart's drop lines to remain active, but appear behind the plotted data. The default display for drop lines seems to be on top. Thanks! Joseph |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Control Z-Order of drop lines in an Excel 2007 chart?
That is the default behaviour and AFAIK there is no way to change that.
Regards, Peter T "Joseph" wrote in message ... Can anyone describe for me the procedure for changing/controlling the z-order of drop lines relative to the plotted data in an Excel 2007 chart? I would like for the chart's drop lines to remain active, but appear behind the plotted data. The default display for drop lines seems to be on top. Thanks! Joseph |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Control Z-Order of drop lines in an Excel 2007 chart?
Maybe play around with the formatting, eg
dim dl as DropLines Set dl = ActiveChart.ChartGroups(1).DropLines dl.Border.LineStyle = xlDash look at weight & colour too Peter T "Peter T" <peter_t@discussions wrote in message ... That is the default behaviour and AFAIK there is no way to change that. Regards, Peter T "Joseph" wrote in message ... Can anyone describe for me the procedure for changing/controlling the z-order of drop lines relative to the plotted data in an Excel 2007 chart? I would like for the chart's drop lines to remain active, but appear behind the plotted data. The default display for drop lines seems to be on top. Thanks! Joseph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| z-order of various lines and bars in an Excel 2007 chart | Excel Discussion (Misc queries) | |||
| How to change order of drop lines relative to the plotted data inExcel 2007 chart | Excel Discussion (Misc queries) | |||
| In Excel 2007 chart with multiple lines, mouse doesn't track lines | Charts and Charting in Excel | |||
| the order of chart lines | Charts and Charting in Excel | |||
| How do I control the order of Custom Toolbars appearing in the Add-Ins Tab of Excel 2007 | Excel Discussion (Misc queries) | |||
Linear Mode
