O'Reilly logo

John Walkenbach's Favorite Excel 2010 Tips and Tricks by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Charts and Graphics

A well-conceived chart can make a range of incomprehensible numbers make sense. The tips in this part deal with various aspects of chart making.

Tips and Where to Find Them

  • Tip 133 Creating a Text Chart Directly in a Range 287

  • Tip 134 Selecting Elements in a Chart 290

  • Tip 135 Creating a Self-Expanding Chart 293

  • Tip 136 Creating Combination Charts 294

  • Tip 137 Creating a Gantt Chart 297

  • Tip 138 Creating a Gauge Chart 299

  • Tip 139 Using Pictures in Charts 301

  • Tip 140 Plotting Mathematical Functions 303

  • Tip 141 Using High-Low Lines in a Chart 306

  • Tip 142 Linking Chart Text to Cells 307

  • Tip 143 Creating a Chart Template 308

  • Tip 144 Saving a Chart as a Graphics File 309

  • Tip 145 Saving a Range as a Graphic Image 311

  • Tip 146 Making Charts the Same Size 312

  • Tip 147 Resetting All Chart Formatting 314

  • Tip 148 Freezing a Chart 316

  • Tip 149 Creating Picture Effects with a Chart 318

  • Tip 150 Creating Sparkline Graphics 319

  • Tip 151 Selecting Objects on a Worksheet 321

  • Tip 152 Making a Greeting Card 323

  • Tip 153 Enhancing Text Formatting in Shapes 325

  • Tip 154 Using Images as Line Chart Markers 327

  • Tip 155 Changing the Shape of a Cell Comment 329

  • Tip 156 Adding an Image to a Cell Comment 330

  • Tip 157 Enhancing Images 331

Creating a Text Chart Directly in a Range

Tip 54 presents an example of the Data Bars Conditional Formatting option, which enables you to create a simple bar chart directly in a range of cells. The Data Bars feature is quick and easy, but if you share your workbook with others who ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required