#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 19
Default 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,
  #2   Report Post  
Posted to microsoft.public.excel.charting
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,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003: How to nudge a chart element or shape on a chart? Ted M H Charts and Charting in Excel 5 June 30th 08 07:08 PM
my curser changed from arrow shape to a cross shape???? bj New Users to Excel 1 February 5th 07 02:47 PM
Chart in a Shape QPapillon Excel Discussion (Misc queries) 1 June 26th 06 04:17 PM
Change the shape of points to crosses in a chart Change shape of points Charts and Charting in Excel 2 January 11th 06 02:36 PM
How to change shape of points in chart? Simon Reed Charts and Charting in Excel 1 August 10th 05 01:08 PM


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"