Table of Contents
Entire Site
Entire Site
Titles Only
Short Cuts
Rough Cuts
Advanced Search
Help
Help
Support Home
Alerts
Top Knowledge Items
Frequently Asked Questions
Account Management
Billing
Content
Content Reader
Mobile
Offline Reading
Sign In
Reactivate
Sign Up
This Book
Excel Hacks
Search
search in
This Book
This Chapter
search for
Contents
Table of Contents
Excel Hacks
Dedication
Credits
Preface
1. Reducing Workbook and Worksheet Frustration
2. Hacking Excel’s Built-in Features
3. Naming Hacks
4. Hacking PivotTables
5. Charting Hacks
Hacks #50-59
50. Explode a Single Slice from a Pie Chart
51. Create Two Sets of Slices in One Pie Chart
52. Create Charts That Adjust to Data
53. Interact with Your Charts Using Custom Controls
54. Three Quick Ways to Update Your Charts
55. Hack Together a Simple Thermometer Chart
56. Create a Column Chart with Variable Widths and Heights
57. Create a Speedometer Chart
58. Link Chart Text Elements to a Cell
59. Hack Chart Data So That Blank Cells Are Not Plotted
6. Hacking Formulas and Functions
7. Macro Hacks
8. Connecting Excel to the World
9. Glossary
About the Authors
Colophon
Copyright
Create Bookmark
Create Bookmark
Create Note or Tag
Create Note or Tag
Print
Print
Zoom Out (Key: -)
Zoom Out
Zoom In (Key: +)
Zoom In
Toggle to Full Screen (Key: f)
Previous (Key: p)
Previous
Next (Key: n)
Next
5. Charting Hacks
Chapter 5. Charting Hacks
PREVIEW
Not a subscriber?
Start A Free Trial
Create Bookmark
Create Bookmark
Create Note or Tag
Create Note or Tag
Print
Print
Zoom Out (Key: -)
Zoom Out
Zoom In (Key: +)
Zoom In
Toggle to Full Screen (Key: f)
Previous (Key: p)
Previous
Next (Key: n)
Next