| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I bring a trendline in front of an object in Excel?
I am trying to place a shape on a chart. I want the trendline to be in front
of the object. How do I accomplish this??? |
|
#2
|
|||
|
|||
|
Hi,
If you use a shape within the chart I don't think you will be able to change the layer its on. It will always be above the charting elements. If you add a dummy series and plot as line or xy-scatter you could use the shape as a custom marker. This you could then control, to some extend. Sort of depend on what the shape is. Cheers Andy Crappy KTP Assistant wrote: I am trying to place a shape on a chart. I want the trendline to be in front of the object. How do I accomplish this??? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
Thank you for the info. This was a question from an engineer. I guess he
wanted to share his frustration with me:). Thanks "Andy Pope" wrote: Hi, If you use a shape within the chart I don't think you will be able to change the layer its on. It will always be above the charting elements. If you add a dummy series and plot as line or xy-scatter you could use the shape as a custom marker. This you could then control, to some extend. Sort of depend on what the shape is. Cheers Andy Crappy KTP Assistant wrote: I am trying to place a shape on a chart. I want the trendline to be in front of the object. How do I accomplish this??? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Microsoft Excel Chart object in VB6 | Charts and Charting in Excel | |||
| Trendline Extract | Charts and Charting in Excel | |||
| "Bring to Front" Data Labels? | Charts and Charting in Excel | |||
| VBA: Where to find Excel Object model? | Excel Discussion (Misc queries) | |||
| How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
Linear Mode
