Jumbabox

This is the last part of the 3 part tutorial on linking PowerPoint to Excel. In this tutorial I will go over how you can link a chart in a PowerPoint presentation to one that you have built in an Excel worksheet.

Related : Part 1 - How to link an Excel worksheet to a PowerPoint presentation
Related : Part 2 - How to link a table in Excel to a PowerPoint presentation
Related : Part 4 - How to link a Pivot Chart in Excel to a PowerPoint presentation
Related : Part 5 - How to link a Pivot Table in Excel to a PowerPoint presentation

Read the rest of this entry »

Everytime I open up or view a report which still has the default Excel 2003 chart formatting visible I cringe, the grey and off blue colours just make me dry reach.

The whole point of charting is to represent data in a consumable medium, so to go against the grain of ugly Excel 2003 charting I’m going to go over some of my do’s and don’ts when it comes to charting in Excel 2003.

F.Y.I : I know Excel 2007 has some great charting options and anti-aliased charts, however I believe this will benefit the users of Excel 2003.

Read the rest of this entry »