Excel Video 71 introduces three chart design options that can help you quickly customize your chart. First we’ll discuss Quick Layout, which offers a variety of preset, chart-type-specific options to customize your chart. These layouts can help you add titles, labels, legends and more to your chart. By using the same Quick Layout, you can make multiple charts look more consistent and professional.
The second topic for Excel Video 71 is Chart Styles, a quick way to consistently change colors across your chart. We’ll also briefly review Themes in Excel 2007 as a way to add different colors to your color palette.
Finally, I’ll show you how to move your chart to a separate tab where you can have room to show more detail and/or more information. You can also move the chart to a different worksheet. I’ve used this command to create several charts, and then put them on all the same worksheet, similar to a dashboard.