98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
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.
Author is a freelance copywriter. For more information on excel software training, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-1156-joseph-and-his-chart-many-colours.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsIndependent Schools Council
Accounts Assistant Rebecca Batson Excel Advanced Would definitely recommend STL to colleagues. Bain & Company
Coordinator, HR Isobel Brunton Excel Intermediate This training was fantastic and I genuinely can't thing of any ways to improve it. Martin was clear, patient and brilliant at explaining everything. Would definitely recommend. The Royal Society
Finance Analyst Yan Zhao Project Management - Framework & Processes I wanted to take a moment to express my sincere gratitude to Tony on the project management training course I recently completed. The course was an exceptional learning experience, and I am thoroughly impressed with the quality of the content and the expertise of the instructors. |
PUBLICATION GUIDELINES