charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Charts

Charts

resolvedResolved · Medium Priority · Version 2007

Ben has attended:
Excel Introduction course

Charts

During the course I gave the chart a Coloured border around the page however the main body of the page remained white. I can't remember how I did it and forgot to ask at the time. Many thanks.

RE: Charts - Contexualized tab!!

Dear Ben

Thank you for attending Excel Intro course. I hope you enjoyed the course and benefited from it.

In Excel 2007 when you create a chart you automatically see a new Contextualized tab called Chart Tools on the top right hand side on the Ribbon. Within this Contextualized tab you have sub tabs namely Design, Layout and Format.

Design is to change the look of your chart very quickly such as changing to different type of chart or placing the chart as a new sheet or changing the styles of the chart. This affects the entire chart AND NOT specific elements of a chart!!

If you want to modify or display certain elements of the charts such as add Chart or x-axis or y axis titles or display values on the series, etc

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips


Server loaded in 0.11 secs.