99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
Joseph And His Chart Of Many Colours
Thu 23rd September 2010
Although now quite successful there is still a little of the hippy idealist inside Joseph: he wears sandals, listens to The Grateful Dead and adds as much colour as is possible to his Excel charts to remind himself of those carefree psychedelic days.
First of all Joseph ditched that plain old white background. He found a lovely photo of a deserted beach and blue sky, which he thought would be ideal for his worksheet.
Go to Format/Sheet/Background and browse for your selected image in the normal way. If you choose an image that is rather 'busy', then you may have to fill the cells with colour in order to read their contents. To remove the background image go to Format/Sheet/Delete Background. Those plain old gridlines are Squaresville to Joseph so he opts for a far more eye-catching colour.
Go to Tools/Options and select the View tab. In the dialog box click on the small arrow next to the box that says Gridline Colour. Then simply select a colour from the drop down menu in the normal way and press OK. If you are using Excel 2007, click the Office button and then click ExcelOptions/Advanced. Scroll until you find and select the Show Gridlines check box. Click Gridline Colour and choose the colour you want. Click OK.
And while he is doing the gridlines, Joseph may as well add a splash of colour to the border of his chart. Select the area you want the coloured border to appear in. Go to Format/Cells and then select the Border tab. From the colour drop down box select the colour you would like your border to be. Before you leave this dialog box, specify the borders you want then click OK. It is possible using this technique to create a border with a different coloured line on each side.
Joseph has a brightly coloured text box above his chart and he has used a psychedelic font. For that 3D effect he has added a drop shadow to the text box so it looks like it is raised from the worksheet
Make sure that your Drawing toolbar is displayed (View/Toolbars/Drawing) Select the text box you wish to apply the shadow to. On the Drawing toolbar there is a square shaped Shadow Style icon. Click on this and then click on your preferred shadow style from the selection available.
These are just a few ways our friend Joseph brightens up his Excel worksheet to take himself out of the humdrum procedure of entering figures. They bring a little fun to Excel, and there are many more ways to enhance the appearance of charts, graphs and text in an application not generally known for its fun side.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
Thank you to Debbie! She was brilliant! :-)
Accent Catering Services Ltd
Very enthusiastic great course for handy hints
BBMV JV Crossrail C510
Excel VBA Introduction
Structure of the course for VBA introduction is a good pace to follow.
Course tutorial feels like a good integration almost like a one to one training day with the class not overcrowded and a good pace.
Enjoyable experience in learning VBA for the first time.