Rounded Corners in Excel 2007 Not Working?!?!

K

Kulprit

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

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
 
K

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/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 said:
;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.


:
-

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???
Click to expand...
 
C

Christopher Scott [MSFT]

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 said:
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 said:
;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.


:
-

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???
Click to expand...
Click to expand...
 
K

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%
 
B

Bernard Liengme

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
 
K

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
 
C

Christopher Scott [MSFT]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set as Default Template not working 0
rounded corners in charts not in newer Excel version 1
how to change color gradients in a bar chart 0
Make a mekko chart in Excel 2007 in three easy Steps 1
Excel 2007 Chart - determining the color of a chart style 1
Visio 2007, associative(dependent) entity with rounded corners 3
Change gradient color in chart for Excel 2007 5
Rounded Corners in an Org Chart 8

Top