modifying charts
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Modifying charts

Modifying charts

resolvedResolved · High Priority · Version 2007

replyReply Fri 10 Dec 2010, 16:16Delegate MARINA said...

MARINA has attended:
Excel Advanced course

Modifying charts

how do i modify charts

For upcoming training course dates see: Pricing & availability

replyReply Sun 12 Dec 2010, 15:02Trainer Nafeesa said...

RE: Modifying charts

Hi Marina,

Thank you for your question.

To modify a chart in Excel 2007:

- Select the chart

- This will then give you the Chart Tools contextual tab (top-right hand side of the Ribbon)

- The Chart Tools has, in essence three sub-tabs: Design, Layout, Format (just below the Chart Tools tab)

- All the tools required will be located in these tabs:
On the Design part of Chart Tools you will find tools to change chart type, move chart, chart styles etc.

On the Layout tab you will find tools to add in elements such as chart titles, axis titles, data labels, error bars etc.

On the Format tab you will find tools to format specific elements of the chart, such as gridlines, columns, text etc.

Please see the link below for further information, follow the links at the bottom of each page to see information on the different elements of Chart Tools.

http://www.homeandlearn.co.uk/excel2007/excel2007s3p3.html


I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.

Regards,


Nafeesa

Microsoft Office Specialist Trainer

replyReply Sun 12 Dec 2010, 15:02Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Sun 19 Dec 2010: Automatically marked as resolved.

 

Please browse our web site to find out more about
excel consulting and other Microsoft training courses.

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard