excel training in london - chart

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training in london - Chart

excel training in london - Chart

resolvedResolved · Low Priority · Version Standard

Jethro has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Chart

how do I change the colour of a chart?

RE: chart

Hi Jethro

Thanks for your question.

You can change the colour of a chart by double-clicking on the part of the chart whose colour you wish to change, then selecting another colour from the Patterns tab and clicking OK.

Enjoy your training today
Amanda


 

Excel tip:

Autonumber in Excel

To create an autonumber field, can use the Offset() function.

In cell A1, enter the number 1.
Then in cell A2, enter this formula:

=OFFSET(A2,-1,0)+1

Then copy the formula from cell A2, down as far as you need.

See also: Autonumber in Excel forum post.

View all Excel hints and tips


Server loaded in 0.17 secs.