Friday, June 10th, 2011

Excel multi color column charts

When you have a great big Excel column chart with heaps of delicious data but all in one series, it makes sense for the chart to be plotted in wonderful technicolor. However that’s an option Excel 2010 doesn’t make it very easy to find. If you try the Chart Tools > Design tab you can choose a multi-color chart but that only colors each series a different color so it won’t work when all your data is in one series.

The solution is to click on one column to select it then right click and choose Format Data Series > Fill group. Locate and check the Vary Colors by Point option and you’ll have a wonderful multi-colored series – much more enlightening than a plain old single color chart don’t you think?

If the colors aren’t to your liking (you are getting just a little bit fussy but I do know exactly what you mean) select the Page Layout tab and check out the Themes – there’s sure to be one which will make your chart perfect.

Helen Bradley

Thursday, September 16th, 2010

Borrowing PowerPoint Image Designs

This stickytape image border comes from the Solstice Theme and here I’ve added it as a new layout in my Oriel Theme.

I saw a recent post on a blog which referred to one of my earlier posts about creating torn edge image effects in PowerPoint 2007. You can see my original post here: http://www.projectwoman.com/2007/03/powerpoint-2007-torn-photo-edges.html.

Someone who responded to the post asked if there was a way of using the photo edges from a theme but not the theme itself. Their problem was they loved the edges but because their organization had a custom theme that was always used, the person wasn’t allowed to change it. The question got me thinking about a solution and here it is!

To use an image design from a PowerPoint theme first create a new file by choosing File > New > Blank Presentation and then choose the New Slide > Picture with Caption Layout – this is the layout typically used to apply fancy styles to images.

Click on the image locator and add an image to the slide – it doesn’t matter what image you add – you just need something so you can see how the image design looks.

Now go to the Design tab and arrow over each of the Themes in turn to see what the image layout looks like. For example, Solstice has a sticky tape edge to the image, Pushpin adds the image with a pushpin background and Opulent has a layered frame look. Flow has a bent corner on the image, Couture has an interesting beveled edge and Summer has a series of illustrative dots around the image. You may find other interesting designs in other Themes such as those that you download from Office Online.

Select the Theme that has the look you want to borrow.

Now choose View > Slide Master and locate the Picture with Caption Layout. Drag over the elements that create the look that you want such as the Pushpin and frame, the sticky tape frame or the circles. Make sure to include the image placeholder. Right click the selected elements and choose Copy.

Now open a file that uses your corporate Theme – or the Theme you prefer to use. Choose View > Slide Master and locate the Picture with Caption Layout slide layout. Right click it and choose Duplicate layout.

Click the image placeholder on this duplicate layout and delete it. Right click on the layout and choose Paste to paste the elements that you copied from the other layout. Move the design elements into a new position, if desired.

You can now adjust the text and title boxes on the layout so that they don’t encroach over the elements that you’ve just added to the design.

When you’re done, click Close Master View.

To save the Theme with the new Layout, from the Design tab open the Themes dropdown palette and choose Save Current Theme and save it.

In future you can use this Theme for your slideshows and to use the layout you created select it from the Layout list where it appears with all the other layouts from the original theme.

Helen Bradley

Wednesday, July 11th, 2007

Configuring Themes in Word 2007

While themes are a gimme for working in PowerPoint, they don’t appear to be as useful in Word as they don’t seem to do much to format the document if you’re not using diagrams or shapes. However the problem isn’t quite this simple. Themes in Word won’t apply to the text in the document if you don’t have a style in place. Use the Home tab to view the Styles option and click Change Styles and select a Style Set. Now, when you choose the Theme, the styles available change.

All of a sudden, themes make a little more sense in Word 2007.

Helen Bradley

Thursday, June 7th, 2007

Love the theme, hate the background image?

Yum, PowerPoint’s new themes. They’re fun, colorful and a far cry from the drab and boring ones we’ve lived with for so long. So, what happens when you love everything about a Theme except its background?

Well, since I’m waxing lyrical about PowerPoint you can probably guess I’m about to let you in on a trick for fixing the background problem in your PowerPoint 2007 theme love affair? Click the Background Styles option in the Design tab and there is an entire selection of different backgrounds all coordinated with the theme. If you change your color scheme the background’s colors change too – sweet!

Helen Bradley