Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 17
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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!


  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 17
Default 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!



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3,346
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Format for an object Nikki Excel Discussion (Misc queries) 1 September 23rd 08 04:19 PM
Conditional format object noyau Excel Discussion (Misc queries) 0 April 11th 08 03:03 PM
Copy/Paste charts as object inside excel Khoshravan Charts and Charting in Excel 1 September 17th 07 02:54 PM
Conditional Format for Object Pivot Man Excel Discussion (Misc queries) 19 June 25th 07 12:44 AM
Charts.Add error '1004' Method 'Add' of object 'Sheets' failed Corey Charts and Charting in Excel 1 December 28th 06 02:15 PM


All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"