Hi Christopher,

Thank you for your help. I find it very difficult to belive that
Rounded Corners are not exposed through the UI in excel 2007. Why would
they make such a great function unaccessible, let alone by VB code.

Please check this link:
http://www.homeandlearn.co.uk/excel2...l2007s3p7.html

They seem to be able to make it work through the UI. Why can't I?!?!?!


Hopelessly desperate,
Bora



'Christopher Scott [MSFT Wrote:
;2720693']Rounded corners are not exposed through the user interface in
Excel 2007. You
can still get rounded corners on a chart through the Visual Basic
object
model.

The code to use follows a format similar to one of two below:

Sheets("Sheet1").DrawingObjects("Chart 1").RoundedCorners = True
Sheets("Sheet1").ChartObjects(1).RoundedCorners = True


--
Thanks,
Christopher

This posting is provided "AS IS" with no warranties, and confers no
rights.


"Kulprit" wrote:
-

Hi,

I can't get rounded corners to work in Excel 2007:


I make a chart
I right click on Char Area
I Select Format Chart Area
A Dialogue Box Pops Up with the following Selections:
- Fill
- Border Color
- Border Styles
- Shadow
- 3-D Format

I select fill and fill the chart area with a color .. say blue

I right click on chart area again and this time select Border Styles
and the following options are available:
- Width
- Compound Type
- Cap Type (drop down menu)
- Join Type (drop down menu)
- Arrow Settings

I click Cap Type and a drop down menu appears with the following
options:
- Square
- Round
- Flat

I select Round

I click Join Type and a drop down menu appears with the following
options:
- Round
- Bevel
- Miter

I select Round

Nothing happens to my chart! The chart corners are as sharp as ever.
Anyone know WTF is going on???




--
Kulprit
-




--
Kulprit