View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default chart over a shape

You can save the shape as a picture and then import that picture into your
plot area. To do so, first save the shape as an image. To save the shape as
an image, start with a workbook that contains only one sheet with your shape
on it. Then save that workbook as a web page in a directory location that
you can refer to later.

Next, open the workbook with your chart in it. Double-click on the chart's
plot area. In the Format Plot Area dialog box, go to Fill Effects - Picture
- Select Picture. Access the file directory where you saved the image above
and then import that image into your chart.

--
John Mansfield
http://www.cellmatrix.net


"Laoballer" wrote:

I have a shape that I have created. The problem is that this shape
covers my scatter plot. Is there a way I could have the data points
be on top of the shape so I can click on the points? I know you can
make the shape transparent but I would like to be able to interact
with the points.

Thanks,