View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Overlapping Fills in XY Scatter Chart

The picture you posted wouldn't load in my browser. Whatever.

I would approach this by drawing an appropriately formatted shape where the
fills are required. Not by hand, but using code:

http://peltiertech.com/Excel/Charts/VBAdraw.html

You can take steps to make this somewhat dynamic, but I don't use it enough
for that, so I delete the old shapes and redraw them as needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ups.com...
I have an XY scatter chart to which I would like to add a number of
overlapping rectangular, black and white pattern and grayscale area
fills. To make things clearer, I have posted a jpg sketch of what I am
after at:

http:/members.aol.com/p4alyo/modelchartfills.jpg

Can this be done in Excel 2000 so that any modifications to the
original curve will automatically resize the fill areas? Or, is this a
"layers" project for a graphics program because of the overlapped
(transparent) patterns needed, as well as the "pictorial" legend?

I did try shift-copying the chart from Excel into Adobe Elements, but
the quality of the copied image was awful, jaggy and fuzzy. Likewise
copying into Microsoft Image Composer was even worse. This leaves me
with another question: What is the proper way to transfer an Excel
chart to a graphics program and still retain a quality image if that
is the way to go with this problem?

Thanks for your help.
Brassman