ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Format Charts as Object (https://www.excelbanter.com/charts-charting-excel/215958-format-charts-object.html)

Tanya M

Format Charts as Object
 
Excel '07 (grrr)

In previous versions of Excel, I could Shift+click an embedded chart to
select it as an object. I could then prevent the chart from rezisizing if I
change the rows and/or column's sizes or added/deleted rows.

I cannot find those options in Excel 2007 (or via the Interactive Guide).
Does it still have that capability and if so, where is it? Please advise.

Thanks!

Andy Pope

Format Charts as Object
 
Hi,

Select chart. Charting Tools Format Size dialog launcher (small arrow
bottom right corner of Size group).

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tanya M" wrote in message
...
Excel '07 (grrr)

In previous versions of Excel, I could Shift+click an embedded chart to
select it as an object. I could then prevent the chart from rezisizing if
I
change the rows and/or column's sizes or added/deleted rows.

I cannot find those options in Excel 2007 (or via the Interactive Guide).
Does it still have that capability and if so, where is it? Please advise.

Thanks!



Tanya M

Format Charts as Object
 
Thank You!

I've been using Office '07 for just over 2 months now and my frustration
level with it increases on a daily basis... :(

"Andy Pope" wrote:

Hi,

Select chart. Charting Tools Format Size dialog launcher (small arrow
bottom right corner of Size group).

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tanya M" wrote in message
...
Excel '07 (grrr)

In previous versions of Excel, I could Shift+click an embedded chart to
select it as an object. I could then prevent the chart from rezisizing if
I
change the rows and/or column's sizes or added/deleted rows.

I cannot find those options in Excel 2007 (or via the Interactive Guide).
Does it still have that capability and if so, where is it? Please advise.

Thanks!




Shane Devenshire[_2_]

Format Charts as Object
 
Hi,

Here are two free downloads from microsoft to help you find something in
2007 that you used to use in 2003.

Interactive Command Guide:
http://www.microsoft.com/downloads/d...displaylang=en

Ribbon Mapping Workbook:
http://office.microsoft.com/en-us/te...128621033.aspx

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Tanya M" wrote:

Thank You!

I've been using Office '07 for just over 2 months now and my frustration
level with it increases on a daily basis... :(

"Andy Pope" wrote:

Hi,

Select chart. Charting Tools Format Size dialog launcher (small arrow
bottom right corner of Size group).

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tanya M" wrote in message
...
Excel '07 (grrr)

In previous versions of Excel, I could Shift+click an embedded chart to
select it as an object. I could then prevent the chart from rezisizing if
I
change the rows and/or column's sizes or added/deleted rows.

I cannot find those options in Excel 2007 (or via the Interactive Guide).
Does it still have that capability and if so, where is it? Please advise.

Thanks!





All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com