John Walkenbach's Favorite Excel 2010 Tips and Tricks

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 ...