ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   chart over a shape (https://www.excelbanter.com/charts-charting-excel/218443-chart-over-shape.html)

Laoballer

chart over a shape
 
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,

John Mansfield

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,



All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com