excel courses - chart
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

excel courses - Chart

resolvedResolved · Low Priority · Version Standard

replyReply Tue 26 Jun 2007, 13:24Delegate kully said...

kully has attended:
No courses

Chart

How do you colour a chart at one go.

For upcoming training course dates see: Pricing & availability

replyReply Thu 5 Jul 2007, 16:00Trainer Amanda said...

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:

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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard