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

basic excel training - changing colour chart series

Forum home » Delegate support and help forum » Microsoft Excel Training and help » basic excel training - Changing colour on chart series

basic excel training - Changing colour on chart series

ResolvedVersion Standard

Changing colour on chart series

Please advise

RE: changing colour on chart series

Hi Richard

The easiest way to change the colour on a chart series is to double-click on one of bars/pie chart piece/line that you want to change the colour of.

A dialogue box will appear that contains all the formatting options for the chart series, usually the option to change colour is on the first tab.

Select the colour you wish to use and click OK.

thanks
Amanda

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

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.1 secs.