• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Professional Charting Techni... > Formatting Charts for a Professional...

Formatting Charts for a Professional Look

What are "professional" chart techniques? And who's to dictate what "professional" is? In my experience, professional techniques separate those who achieve and create impact from those who don't. To be able to say a thousand words with a single chart or a series of charts can be of extreme importance. There's a certain standard in the business world, as you may have noticed, but no one ever says what that standard is. Well, in this chapter, you'll learn some of those basic "professional" elements that can help you achieve greater impact with your charts. In addition, you'll learn some new ways to combine charts with their source worksheets.

This chapter reviews several distinctly different chart types. Learning ways to mix and match information will help you become more creative in utilizing the charting capabilities in Excel. I discuss such techniques as erasing borders and backgrounds, which is one of the key elements in being able to combine and manipulate information on worksheets with charts. Another way to combine tools in Excel is to use form controls. The best way I've found to use form controls with charts is when you have to continually extract cost-to-date information or production-to-date information. This technique is also described.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint