Rounded Corners in Excel 2007 Not Working?!?!

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???

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

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

Originally Posted by Christopher Scott [MSFT]

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

Hmm. I didn't realize the rounded corner checkbox was still in there.

I wonder if you are formatting the wrong thing. The article you refer to
says you should be looking for "Line" category in the dialog, not "Border
style". Make sure you have the entire Chart Area selected, not the plot area
or something else. The dialog should be titled "Format Chart Area". I'll
have to check on my own machine tomorrow.


--
Thanks,
Christopher

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


"Kulprit" wrote:


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

Thanks again.

Yes I realized that they are looking for the "line option" but it is not available to me. 100% it says "Format Chart Area" and not Plot Area. I would consider myself above average in Excel (hell, wrote my master's thesis in it) so I don't think I am making any newb mistakes.

Check this article out: They are doing rounded corners with the "Border Styles" option. I notice that I do not have any check mark box for "Rounded Corners" in my excel 2007.

http://www.cob.sjsu.edu/splane_m/assign4.htm
Add a shadow and rounded corners to the chart. Note: the rounded corners option is only available in worksheets, not in chart sheets.
2007 - Right click on the chart background.
Select the last option "Format Chart Area."
Select "Border Styles." Put a check next to "Rounded Corners."
Select "Shadow" Change the "Size" option to 105%

1) Right click the chart border; you should see an item in the hsortcut menu
Format Chart Area; open this
2) Open the Border Style tab
3) Right at the bootm is the ROunded Corners box; check it
The effect is not too obviuos until tou unseelct the chart
best wishes
--
Bernard Liengme MVP
www.stfx.ca/people/bliengme


"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

3) Right at the bootm is the ROunded Corners box; check it
The effect is not too obviuos until tou unseelct the chart

Hi Bernard,

Thanks for your post. That is the problem there is not a checkbox for rounded corners!!!

Please see this screen shot:
http://www.life2o.com/rounded_corners.jpg

I see. So you are on a chart sheet, which makes a big difference. You could
not have rounded corners on a chart sheet in Excel 2003 either. Just shadow.

Sorry if I'm wrong here; just shooting in the dark.
--
Thanks,
Christopher

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


"Kulprit" wrote:


3) Right at the bootm is the ROunded Corners box; check it
The effect is not too obviuos until tou unseelct the chart

Hi Bernard,

Thanks for your post. That is the problem there is not a checkbox for
rounded corners!!!

Please see this screen shot:
http://www.life2o.com/rounded_corners.jpg




--
Kulprit