Rounded Corners in Excel 2007 Not Working?!?!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kulprit - 12 Apr 2008 23:19 GMT

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

Signature

Kulprit

Reply to this Message

Christopher Scott [MSFT] - 13 Apr 2008 01:37 GMT

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

Signature

Thanks,
Christopher

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

> Hi,
>
[quoted text clipped - 38 lines]
> Nothing happens to my chart! The chart corners are as sharp as ever.
> Anyone know WTF is going on???

Reply to this Message

Kulprit - 13 Apr 2008 04:55 GMT

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/excel2007/excel2007s3p7.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
[quoted text clipped - 51 lines]
> Nothing happens to my chart! The chart corners are as sharp as ever.
> Anyone know WTF is going on???

Signature

Kulprit

Reply to this Message

Christopher Scott [MSFT] - 13 Apr 2008 21:13 GMT

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.

Signature

Thanks,
Christopher

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

> Hi Christopher,
>
[quoted text clipped - 66 lines]
> > Nothing happens to my chart! The chart corners are as sharp as ever.
> > Anyone know WTF is going on???

Reply to this Message

Kulprit - 14 Apr 2008 02:26 GMT

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%

Signature

Kulprit

Reply to this Message

Bernard Liengme - 14 Apr 2008 04:27 GMT

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

Signature

Bernard Liengme MVP
www.stfx.ca/people/bliengme

> Hi,
>
[quoted text clipped - 38 lines]
> Nothing happens to my chart! The chart corners are as sharp as ever.
> Anyone know WTF is going on???

Reply to this Message

Kulprit - 14 Apr 2008 06:50 GMT

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

Signature

Kulprit

Reply to this Message

Christopher Scott [MSFT] - 14 Apr 2008 08:18 GMT

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.

Signature

Thanks,
Christopher

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

> 3) Right at the bootm is the ROunded Corners box; check it
> The effect is not too obviuos until tou unseelct the chart
[quoted text clipped - 6 lines]
> Please see this screen shot:
> http://www.life2o.com/rounded_corners.jpg

Reply to this Message