98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel ribbon options
Excel ribbon options
Resolved · Medium Priority · Version 2007
Tue 25 Aug 2009, 10:39Delegate Sally said...
Sally has attended:
Excel Introduction course
Excel Intermediate course
PowerPoint Intermediate Advanced course
Excel ribbon options
Some options are not available on Excel
I prepared a chart. When clicking on it to access layout ribbon, in Background: Chart Wall/Chart Floor/3-D Rotation are all greyed out so I cant use them. Nothing happens when you click on them.
Also in Layout ribbon, under Analysis: Lines/Up&Down are also greyed out.
Is there something I should set up in Excel to activate them?
Also in my sales chart, how do I get the Vertical axis to have values in increments of 20,000 like in the manual? My chart only has a vetical axis with increments in 50,000 stages.
Tue 25 Aug 2009, 11:22Trainer Amanda said...
RE: Excel ribbon options
Hello Sally
Thank you for your question.
If there are certain option greyed out, it may just be to do with the type of chart you are working with - maybe these particular options are not available to be adjusted with the chart type you are using.
To change the increments on the vertical axis, right-click on the axis (or axis labels) and then select Format Axis. In the Axis Options category, you can alter the Major Unit setting which controls the increment size.
Hope this helps.
Kind regards
Amanda
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hide columns in an Excel 2010 WorksheetIf you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns. |
