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

microsoft-excel-courses - charts

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

microsoft-excel-courses - Charts

ResolvedVersion Standard

Julia has attended:
Excel Introduction course

Charts

How do I change the colours on a bar chart?

RE: charts

Hi Julia

Thank you for your question, apolgies for the delay in replying.

Once you have created a chart, the rule of thumb is that if you double-click the part or area of the chart you wish to change, you will find all the formatting options for that piece of the chart.

So if you hold your mouse over one of the bars and double click, you will find that you can change the bar colour on the Patterns tab.

I hope this helps.
Amanda

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

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