Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training+excel+microsoft - Charts & graphs

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

training+excel+microsoft - Charts & graphs

Resolved · Low Priority · Version Standard

Reply Wed 24 Oct 2007, 13:49Delegate Elaine said...

Elaine has attended:
Excel Intermediate course
Excel Advanced course

Charts & graphs

how do i get colours onto graphs ?

For upcoming training course dates see: Pricing & availability

Reply Fri 26 Oct 2007, 15:53Trainer Amanda said...

RE: charts & graphs

Hi Elaine

Thank you for your question.

To colour a part of your chart (bars, pie sections lines) select the bar/pie section/line and then right-click on it and select Format Data Series from the menu.

You will then be able to change the colour on the Patterns tab.

To change the colour of the chart background, select the Plot Area, then right click and select Format Plot Area. Change the background colour on the Patterns tab.

I hope this helps.
Amanda

Excel articles

· Why Excel Has More Cloud Coverage
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Use Hyperlinks In Excel To Make An Impact
· How To Create An Argument With Excel
· Importing Excel Data Into Access

Excel tip:

Change the default location for opening and saving spreadsheets

If you are always opening spreadsheets from and/or saving documents to a specific location that is not My Documents, save time by setting this folder as the default for opening files from and saving files to.

Here's how:
1. Go to Tools - Options.

2. Select the General tab.

3. Enter the pathname of the folder you wish to make the default in the Default File Location box (hint: it will be easier to use Windows Explorer to navigate to this folder, then copy and paste the pathname from the address bar at the top of the Windows Explorer screen).

4. Click OK.

You have now changed the default folder for opening and saving spreadsheets.

View all Excel hints and tips