| |
| |
| Introduction | |
| |
| |
| About This Book | |
| |
| |
| Foolish Assumptions | |
| |
| |
| How This Book Is Organized | |
| |
| |
| Icons Used In This Book | |
| |
| |
| |
| Say Hello to Crystal Xcelsius | |
| |
| |
| |
| Introducing Crystal Xcelsius | |
| |
| |
| Overcoming Static Cling | |
| |
| |
| More Than Just Fancy Graphics: The Benefits of Using Crystal Xcelsius | |
| |
| |
| Creating more robust presentations with interactive summary and detail layers | |
| |
| |
| Building what-if analyses into your presentations | |
| |
| |
| Building tools that help make decisions | |
| |
| |
| Crystal Xcelsius under the Hood | |
| |
| |
| Importing data | |
| |
| |
| Building the visual model | |
| |
| |
| Compiling and publishing the dashboard | |
| |
| |
| |
| Taking Crystal Xcelsius for a Spin | |
| |
| |
| Creating Your First Dashboard | |
| |
| |
| |
| Importing the Excel model | |
| |
| |
| |
| Building your visual model | |
| |
| |
| |
| Testing and publishing your visual model | |
| |
| |
| Getting Fresh with your Dashboard | |
| |
| |
| |
| Getting Started with the Basics | |
| |
| |
| |
| Interacting with Single Value Components | |
| |
| |
| Managing Interactivity: Input vs. Output | |
| |
| |
| Understanding Scale Behavior | |
| |
| |
| Building a Loan Payment Calculator | |
| |
| |
| |
| Calling Attention to Alerts | |
| |
| |
| The Anatomy of the Alert Tab | |
| |
| |
| Alert Method | |
| |
| |
| Alert Definition | |
| |
| |
| Alert Levels | |
| |
| |
| Alert Level Display | |
| |
| |
| Target | |
| |
| |
| Applying Your First Percent Alert | |
| |
| |
| Applying Your First Value Alert | |
| |
| |
| |
| Getting Graphic with Charts | |
| |
| |
| The Basics of Crystal Xcelsius Charts | |
| |
| |
| Understanding the chart types | |
| |
| |
| Creating Your First Chart | |
| |
| |
| Understanding scale behavior | |
| |
| |
| Leveraging the run-time scaling options | |
| |
| |
| Changing Chart Appearance | |
| |
| |
| Appearance tab options | |
| |
| |
| Sub-tab sections by chart type | |
| |
| |
| Understanding Combination Charts | |
| |
| |
| Combination chart ground rules | |
| |
| |
| Creating a combination chart with three data series | |
| |
| |
| Adding a series to a combination chart | |
| |
| |
| |
| May I Please See the Menu? | |
| |
| |
| Delivering Choices with a Selector Component | |
| |
| |
| Understanding the Insert Option Property | |
| |
| |
| Position | |
| |
| |
| Label | |
| |
| |
| Value | |
| |
| |
| Rows | |
| |
| |
| Columns | |
| |
| |
| Status List | |
| |
| |
| Working with the Filter Component | |
| |
| |
| Creating Your First Filtered Dashboard | |
| |
| |
| |
| Get Fancy with Advanced Components | |
| |
| |
| |
| Getting Geo-Graphic with Maps | |
| |
| |
| Understanding the Concept of Regions | |
| |
| |
| Creating a Basic Map-Based Dashboard | |
| |
| |
| Applying Alerts to Map Components | |
| |
| |
| Assigning a value to each Region | |
| |
| |
| Assign a target to each Region | |
| |
| |
| Dynamically Feeding Data to Map Components | |
| |
| |
| |
| Focusing in on Dynamic Visibility | |
| |
| |
| Seeing the Basics of Dynamic Visibility | |
| |
| |
| Dynamic visibility in a nutshell | |
| |
| |
| Applying basic dynamic visibility | |
| |
| |
| Implementing Menu-Based Visibility | |
| |
| |
| |
| Working with Crystal Xcelsius Professional | |
| |
| |
| Creating Drill-Down Charts | |
| |
| |
| Using Accordion Menu Components | |
| |
| |
| Working with Picture Menus | |
| |
| |
| Using Interactive Calendar Components | |
| |
| |
| |
| Wrapping Things Up | |
| |
| |
| |
| Adding Style and Personality to Your Dashboards | |
| |
| |
| Employing the Five Formatting Must-Haves | |
| |
| |
| Using Copy and Paste | |
| |
| |
| Using the Properties window | |
| |
| |
| Using the alignment and position functions | |
| |
| |
| Using the Grouping function | |
| |
| |
| Using the Object Browser | |
| |
| |
| Adding Style and Personality | |
| |
| |
| Using Art & Backgrounds components | |
| |
| |
| Applying color schemes with global style | |
| |
| |
| Discovering Skins and Templates | |
| |
| |
| Changing skins | |
| |
| |
| Using templates to save time | |
| |
| |
| |
| Taking Your Dashboards to Market | |
| |
| |
| Exporting a Visual Model | |
| |
| |
| Paying Attention to Distribution Matters | |
| |
| |
| Macromedia Flash considerations | |
| |
| |
| Naming considerations | |
| |
| |
| Directory considerations | |
| |
| |
| Canvas size considerations | |
| |
| |
| Sending Data Back to Excel | |
| |
| |
| Incorporating Input from Others | |
| |
| |
| |
| The Part of Tens | |
| |
| |
| |
| Designing Effective Excel Models: Ten Best Practices | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| Ten Cool Crystal Xcelsius Tricks | |
| |
| |
| Creating a Waterfall Chart | |
| |
| |
| Password-Protecting Your Dashboard with Dynamic Visibility | |
| |
| |
| Highlighting the Below-Average Data Points in a Chart | |
| |
| |
| Making a Data Series Disappear and Reappear | |
| |
| |
| Creating a Scrolling Chart | |
| |
| |
| Using Conditional Formatting to Create Regions on a Map | |
| |
| |
| Making Your Own Map Component | |
| |
| |
| Adding an Export to PowerPoint Button | |
| |
| |
| Nesting a Dashboard within Another Dashboard | |
| |
| |
| Using Crystal Xcelsius to Build Your Web Site | |
| |
| |
| |
| Frequently Asked Questions: Two Sets of Ten | |
| |
| |
| Basic Questions about Crystal Xcelsius and Excel | |
| |
| |
| Common Error Messages and What They Mean | |
| |
| |
| Commonly Asked Component Questions | |
| |
| |
| |
| Ten (or So) Real World Examples | |
| |
| |
| Load Optimization (Logistics) | |
| |
| |
| Instructor Staffing (Education) | |
| |
| |
| Basic ROI Calculator (Finance) | |
| |
| |
| Service Outage Analyzer (IT) | |
| |
| |
| Fuel Cost Analysis (Transportation) | |
| |
| |
| Software Development | |
| |
| |
| Site Statistics (Web Site Management) | |
| |
| |
| Google AdWords Tracker (Marketing) | |
| |
| |
| Headcount Visibility Reporting (HR) | |
| |
| |
| |
| Going Beyond Spreadsheets | |
| |
| |
| Index | |