Chart sheets

When you create a chart on a chart sheet, the chart occupies the entire sheet. If you plan to print a chart on a page by itself, using a chart sheet is often your better choice. If you have many charts to create, you may want to create each one on a separate chart sheet to avoid cluttering your worksheet. This technique also makes locating a particular chart easier because you can change the names of the chart sheets’ tabs to provide a description of the chart that it contains.

The Excel Ribbon changes when a chart sheet is active, similar to the way it changes when you select an embedded chart. Excel displays a chart in a chart sheet in WYSIWYG (What You See Is What You Get) mode: The printed chart looks just like the image on the chart sheet. If the chart doesn’t fit in the window, you can use the scroll bars to scroll it or adjust the zoom factor. You also can change its orientation (tall or wide) by using Page Layout?Page Setup?Orientation.

If you create a chart on a chart sheet, you can easily convert it to an embedded chart. Choose Chart Tools? Design?Location?Move Chart to display the Move Chart dialog box. Select the worksheet that will hold the embedded chart from the As Object In drop-down box.

Excel deletes the chart sheet and moves the chart to the sheet that you specify. This operation also works in the opposite direction: You can select an embedded chart and relocate it to a new chart sheet.

Add to Technorati Favorites


// Related Posted - GOOGLE!

Loading



Related Websites
No comments yet.

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>