Tuesday, January 10th, 2012

Pattern fills for your Excel 2007 charts

Excel2007 black and white pattern fills for charts Pattern fills for your Excel 2007 charts

In Excel 2003 and now in Excel 2010 , there are pattern fills which you can use to fill chart bars so your charts print just great in black and white.

Unfortunately the same feature was removed from Excel 2007 – wtf? I have no clue why but it was but it has to be a very silly thing to have done.

If you are using Excel 2007 and you need to use pattern fills with a chart you are out of luck – well not really – you just need to read the rest of this tip because I can tell you how to put the fills back into Excel 2007.

To begin, download this handy add-in: http://officeblogs.net/excel/PatternUI.zip

The zip file contains a single file patternUI.xlam which you need to extract and place somewhere you will find it easily and where it won’t get deleted by accident. You could make an Excel add-ins folder for it, for example.

Once you’ve done this, open Excel 2007 and choose the Office button > Excel Options > Add-ins and from the Manage dropdown list, select Excel Add-ins and click Go. This opens the old Add-ins dialog from earlier versions of Excel. Click Browse and locate the .xlam file that you just unzipped and placed somewhere safe. Select it and click Ok. Ensure that the PatternUI option appears in the Add-ins available list and that it is checked and click Ok.

Now create an Excel chart. Once you have you chart, click on the data series to fill with a pattern – if you have a single series plotted then select just one of the columns at a time. Select the Chart Tools > Format tab and notice that you now have an option called Patterns available. Click the Patterns option and select a pattern to apply to the currently selected chart series or column. Click on each series or column in turn and apply a pattern to it. When you are done, you can print your chart as usual.

Installed add-ins are managed automatically by Excel so you will find that the add-in will still be there and accessible next time you use Excel.

If you are using Excel 2010 you don’t need this add-in as the pattern fills are back where they should have been all the time.

Excel black and white pattern fills for charts Pattern fills for your Excel 2007 charts

Friday, July 1st, 2011

Outlook 2010: backup gets worse (if that’s possible)

Outlook 2010 backup opener Outlook 2010: backup gets worse (if that’s possible)

If you thought Microsoft has, over the years, right royally messed up the process of backing up your Outlook PST files then the situation with Outlook 2010 has only got worse.

For Outlook 2002, 2003 and 2007 users Microsoft provided a Personal Folders Backup Tool that you could download from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=9003 which would install a backup routine into Outlook.

Outlook 2010 backup 1 Outlook 2010: backup gets worse (if that’s possible)

Having done this you could then select File > Backup to backup your PST file.

Over the years of course, this has prompted questions as to why the thing wasn’t built in to Outlook in the first place? It is a stupid and ill-considered omission in my book, but let’s put that aside for now because the problem only gets worse for Outlook 2010 users.

You see the Personal Folders Backup Add-In doesn’t work with Outlook 2010.

As I say repeatedly it’s Microsoft’s world and we just live in it. Microsoft knows that there’s a problem and explains that the failure of the add-in is due to the new fast shutdown functionality in Outlook. If you visit this website http://support.microsoft.com/kb/2030523 you can click the Fix It For Me link and Microsoft will fix the problem for you.

Outlook 2010 backup 2 Outlook 2010: backup gets worse (if that’s possible)

Don’t even bother asking why there is a problem in the first place. There should be (and it’s inexcusable that there is not)  a backup routine built in to Outlook to make it easy for you to backup your PST file.

Consider this – everything you receive or send via email is in that PST file – and that includes attachments! Lose it and you lose the lot. Worse still, there is a physical limit to its size – beyond around 2GB the thing can become horribly unstable. So you will need to back it up or risk losing it all if your computer crashes or the thing becomes corrupt.

So, if your using Outlook 2010, run (don’t walk) to this site: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=9003 and download and install the Personal Folders Back up tool for Outlook 2002, 2003 and 2007 (yep! I know you’re using Outlook 2010! Then go to this site: http://support.microsoft.com/kb/2030523 and run the Fix It Tool – you have to have the backup tool installed first.

If you don’t like clicking Fix It buttons then there’s a detailed explanation in that same Knowledge Base article explaining how to fix the problem manually – basically it’s a fairly simple registry fix.

Monday, January 24th, 2011

Photoshop – Free Valentine heart shapes download

free valentine heart shapes photoshop Photoshop   Free Valentine heart shapes download

I’ve been messing around in Photoshop this week making heart shapes. As a result I wrote a blog post to show you how to make these shapes yourself.

Just in case you want to take the easy way out, here is a free download with a collection of 14 hearts just in time for you to use for Valentine’s Day projects.

As with all  my downloads, you are free to use them for non commercial purposes, they may not be given away, they may only be downloaded from this site. Commercial licenses are available by request.

Wednesday, January 5th, 2011

Cool Photoshop Textures – free – commercial use

Textures photoshop free download Cool Photoshop Textures   free   commercial useOne of the biggest problem designers and graphic artists have is in finding content that can be used commercially. It often seems that even content you pay for you have to jump through hoops to read the fine print to determine what exactly you can do with it and it often  has overly restrictive limits.

Today I found a great site. Great because of a number of things:

1. The content is free.

2. The textures are gorgeous and varied and hi-res.

3. You are free to use them for commercial purposes.

4. Attribution is appreciated but not required.

Verbatim, here is the terms of use: “Lost & Taken textures are made freely available for use in both personal and commercial projects including web templates, designs, and other materials intended for distribution. Attribution is appreciated, but not required.”

The textures fall into a  number of categories including: Vintage damask, torn paper, skin, bubbles, wallpaper, book covers, subtle grunge and lots more. Check out the vintage wallpaper ones on the home page they are so totally cool.

To view and download textures head to the Gallery.

Tuesday, January 4th, 2011

Microsoft PowerPoint – Free!

Microsoft Office online Microsoft PowerPoint   Free!
If you don’t already own Microsoft PowerPoint 2010, did you know you can download a 30 day trial version for free from Microsoft?

PowerPoint comes bundled with Office 2010 and the entire downloadable trial version of Office is available from the Microsoft web site. If you like what you see, you can purchase the full version later on.

If you like PowerPoint but can’t afford to shell out for the suite, why not settle for a cut down version – free – available online? You can find PowerPoint at www.skydrive.com sign in using a Windows Live ID – if you don’t have one (but you probably will), you can sign up for one here. Then click the Office link at the top of the page and you can choose to create a new PowerPoint presentation online.

The PowerPoint tools are a cut down version of the full PowerPoint program but they are all you need to get a good start on a presentation – you even have access to a range of great looking themes to kick start your presentation.

Better still you can share your PowerPoint presentation with others so they can view it and even edit it online and you can download the finished file to your computer. Of course, your files are stored online too so you can access them any time you like and Microsoft gives you a hefty 25GB of online storage – more than enough to create all the presentations you’re ever likely to need.

Thursday, December 30th, 2010

Kawaii Panda Shape – free download

Photoshop kawaii panda shape Kawaii Panda Shape   free download

I’ve been messing around today making shapes in Photoshop. This is my final Panda Kawaii shape which I’m offering as a free downloadable shape that you can import into Photoshop and use yourself.

I find shapes are easiest to build up from pieces so I make each piece then build them up bit by bit into the final shape by combining the paths. It’s painstaking work but ultimately rewarding to have a custom shape you can use anytime and scale to any size.

Here is the link to download the shape file – you can use the shape for your own designs but you aren’t permitted to sell the shape or offer it for download from your own site.

Photoshop kawaii panda shape build e1293744741889 Kawaii Panda Shape   free download

Wednesday, January 13th, 2010

New free Steampunk brushes

 

 New free Steampunk brushes

I just made a set of fun Photoshop steampunk brushes. They are made from clock parts and they have a photographic quality to them. The collection includes a range of gears and some funky metal bits too. They are sized upwards of 600 pixels and some are as large as 2400 pixels.

They are free brushes for personal use and an inexpensive commercial license is available.

You can download them from projectwoman.com.

Saturday, November 29th, 2008

Getting Vista’s Windows Media Player to play videos

Vista’s Windows Media Player will play audio and video files, only if it has the codecs for them. Codecs are like translation programs, without the codecs you get exactly zip, nada, zero on the screen. Sucks huh?

Unfortunately not all the codecs you need are included in Vista so you might try to play a video and find you have no visuals although the sound might play just fine, or vice versa. The solution is to download the codecs you need to play the range of media files you’re likely to encounter.

To locate the codecs you need, visit softpedia.com and search for the Vista Codec package. At the time of writing the latest version is 5.0.3 and it can be found here.

Download it and install it and you should be right to play just about any media file around.

This is the file which Microsoft should have provided. These codecs should be supplied with the player, after all, what use is a DVD or audio player if it doesn’t play disks? If you buy a physical DVD player you don’t expect to have to go out and buy something extra to make the player and your disks compatible. Just because the player is software doesn’t excuse the lack of compatibility.

So, yes, it sucks you have to go find and download this file, but kudos to the guy who did all the work so we don’t have to.

Friday, September 26th, 2008

Movie Maker Beta goes Live

In the spirit of making key applications available online rather than as standalone programs on your desktop, Microsoft has launched Windows Movie Maker Beta live.

Find and download it from: http://download.live.com/moviemaker

It’s a long time since Windows Movie Maker was updated – in computer terms it’s almost geriatric! It will be good to see it given a makeover and some added functionality.

Saturday, September 22nd, 2007

Windows Live Photo Gallery Beta is here

photogallery 793878 Windows Live Photo Gallery Beta is here

This cool new Photo Gallery tool from Windows Vista is at last available for Windows XP.

This was a Vista only program but, recently, it was released as a private beta, now it’s public. You can download it from here: http://get.live.com/betas/photogallery_betas.

To use it, you’ll need to have Windows XP SP2 installed and expect the download and installation process to take a while – actually, scrub that, it takes ages.

However, it looks great, it has the Vista look to it and it’s a worthy replacement for the Windows Picture and Fax Viewer.

It has a great panorama assembly tool under the Make menu – just select the panorama images first then click this option.

Overall the program is pretty good and probably the biggest missing omission is a good rotation tool. While it rotates in 90 degree increments it sorely needs a tool that rotates in tiny quantities like fractions of a degree.