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