Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2007 Charting 1

Status
Not open for further replies.

herkiefan

Technical User
Oct 13, 2006
97
US
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
 
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.
 
([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.
 
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
 
Glad I could help!
[cheers]

[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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top