Hi again,

I have come a little closer to the mystery, but the drama tightens...
ACTUALLY,
Manually setting the Column Borders (not the Fills) to Solid from Automatic,
makes the corresponding EMF/WMF objects become distinct Rectangles and not
Freeforms.

BUT,
Doing the same thing with VBA, (by setting Color =0), creates solid borders
in the chart, but does not affect the "EMFprocess" and results in Freeform
objects in PPT!

Furthermore,
Doing it with VBA actually "destroys" other manually set borders to Solid
(that previously worked) and these thereafter become Freeform instead of
Rectangle.

Finally
To reset the VBA damage, I need to reset to automatic, save and then reset
the border manually.


This is WEIRD!
Help really needed

Thanks,

Bob

"Bob" <bobone a pointer.se wrote in message
...
Hi,

A "Marimekko/Lasagne chart" is a valuable format that MS does not support.
Although several excellent solutions have been developed (S Bullen, etc),
they have their flaws.

For 2003 I have some great code that disassembles a Stacked Column chart,
scales the Category-axis and puts it back together again. This is done in
PPT with VBA.
There is actually an order for breaking up a chart that I have parsed (in
object order: Points, Value axis,Category axis, Point Labels, Value Axis
delimiters, Category names and finally the Legend (any comment to this?)

2007 creates problems! (the OLE disconnection is a pain, but I understand
SP2 (Q12009) will adress this)

My largest concerns a
- new objects (freeform) are created that tend to group other objects
(rectangles). These cannot be broken up.
- inconsistancy. Some charts (that look identical) create the distinct
Rectangles (that I want) others Freeforms that lock in "my" rectangles.

Question:
- how can I control what is being created in the "save as EMF/WMF process.
I.e. don't want freeforms!!!

I have tried fooling around with the Forecolors and Borders of the Columns.
At first I thought that explicitelt defining a solid color would help.
I have two test charts looking identical, as far as I can tell, one with
solid fill one with automatic fills. The first one creates rectangles, the
latter grouped freeforms. Unfortunately, changing the automatic coloring to
solid does not help... there must be something else that differs...

What?

Really need help...
(Steve and Ben wer involved in a thread a year ago regarding "Excel 2007
line-chart pasted as an enhanced metafile - editing")

Thanks,

Bob