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

training+excel+microsoft - charts graphs

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

training+excel+microsoft - Charts & graphs

ResolvedVersion Standard

Elaine has attended:
Excel Intermediate course
Excel Advanced course

Charts & graphs

how do i get colours onto graphs ?

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 tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.