Tabla de Contenidos: “…Dealing with Splits Using the Adjusted Close Column -- Creating a Line Chart to Show Closing Prices -- Adding Volume as a Column Chart to the Line Chart -- Creating OHLC Charts -- Producing a High-Low-Close Chart -- Creating an OHLC Chart -- Adding Volume to a High-Low-Close Chart -- Creating Candlestick Charts -- Changing Colors in a Candlestick Chart -- Adding Volume to a Candlestick Chart -- Manually Creating a Candlestick Chart with Volume -- Creating a Candlestick Stock Chart Showing Volume and a Competitor -- Creating a Live Chart by Using a Web Connection -- Making Charts Small for Use in Dashboards -- Next Steps -- 7 Advanced Chart Techniques -- A Tool Chest of Advanced Charting Techniques -- Mixing Two Chart Types on a Single Chart -- Moving Charts from One Worksheet to Another -- Using Shapes to Annotate a Chart -- Making Columns or Bars Float -- Using a Rogue XY Series to Label the Vertical Axis -- Converting a Series to Gridlines -- Showing Several Charts on One Chart by Using a Rogue XY Series -- Using Multiple XY Series to Create a Trellis Chart -- Creating Dynamic Charts -- Using the OFFSET Function to Specify a Range -- Using VLOOKUP or MATCH to Find a Value in a Table -- Combining INDEX and MATCH -- Using Validation Drop-Downs to Create a Dynamic Chart -- Using Dynamic Ranges in a Chart -- Creating a Scrolling Chart -- Modifying the Scrollbar Example to Show the Last 12 Months -- Creating Advanced Charts -- Thermometer Chart -- Benchmark Chart -- Delta Chart -- Amazing Things People Do with Excel Charts -- Next Steps -- 8 Creating and Using Pivot Charts -- Creating Your First Pivot Chart -- What's New in Excel 2007 Pivot Tables -- Deciding Which Comes First: The Table or the Chart -- Rules for Preparing Underlying Pivot Data -- Creating Your First Pivot Chart -- Changing the Chart Type and Formatting the Chart…”