Excel 2007 Charting 1

[herkiefan]

Hello gurus!

How would I do the following action from Excel 2003 in Excel 2007?

Click on the chart
right-click
select properties
select protection
click on "move but don't size" (or something similar to that).

I use the outline/grouping function when charting and in 2007 I can not find a way to prevent the chart from changing size as I view/hide columns.

Any and all help would be greatly appreciated.

Mike

“Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

 

[AnotherHiggins]

Click on the chart and you'll see that three new ribbons become available.

Above them is a green tab that says, Chart Tools[b/].

Go to Chart Tools > Format then click on the little arrow at the bottom right of the Size section.

You're now in a dialog box named Size and Properties.

Go to the Properties tab.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[AnotherHiggins]

([gray]grumble grumble didn't hit preview...[/gray])

I'll try that one more time:

Click on the chart and you'll see that three new ribbons become available.

Above them is a green tab that says, Chart Tools.

Go to Chart Tools > Format then click on the little arrow at the bottom right of the Size section.

You're now in a dialog box named Size and Properties.

Go to the Properties tab.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[herkiefan]

John-
You are so awesome! I've searched every where on the web and within Excel to find this.

Thank you. Thank you.



“Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.”-Albert Einstein

 

[AnotherHiggins]

Glad I could help!


[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.