Excel Charts

Hi Terry,
OK thanks for that, didnt catch the bit where you said you had pressed escape twice or wouldnt have launched into all the keyboard commands, answer to your original problem then, - sorry, dont know how to do it without the mouse, regards Pete

Dear Terry

Thank you for your question!

I assume that you are using Excel 2007 and if I am correct in thinking then you want to select various parts of a chart e.g. legend, series, Chart Area, Plot Area, etc... without the use of the mouse.

If this is the nature of your query then please follow these guidelines:

I hope you are aware that in Excel 2007 instead of remembering the short cut keys you can use the Access Keys.

All you have to do is press the ALT button which will display the letters on the Ribbon and Numbers on the Quick Access Toolbar.

If you have already created the chart in a separate sheet then you should be able to see a contextualized tab called Charts Tools. You'll notice it has three Tabs i.e. Design , Layout and Format under the Charts Tools.

If you want to select various parts of the Charts simply Press ALT button and then when the Access Keys appear type JA to select the layout Tab.

Type E to select the Chart Elements Box

Once you have the cursor blinking you can use the Down arrow on the keyboard to select other parts of the chart.

If you want to modify parts of the charts then you can continue to use the ALT Key and choose the key combinations to modify the chart.

I hope this helps. If it has helped in resolving your query then please mark the post as Resolved

Many thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003