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

excel courses - chart

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - Chart

excel courses - Chart

ResolvedVersion Standard

kully has attended:
No courses

Chart

How do you colour a chart at one go.

RE: Chart

Hi Kully

Thank you for your question.

If you are referring to the bars that make up one series in a chart, e.g. you might have a series of bars that are coloured blue in the chart, you just double-click on one of the bars and then choose a different colour and click OK. All the blue bars should then change colour to the new colour you have chosen.

Amanda

Excel tip:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

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