MS-Excel /
General Formatting
Excel Charts Tips
- To create a chart with a single keystroke, select the data you want to chart and press Alt+F1. The result is an embedded
chart of the default chart type. To create the chart on a chart sheet, press Alt+F11 instead of Alt+F1.
- You can use charts to summarize large sets of data in an easy-to-follow visual format.
- You're not stuck with the chart you create; if you want to change it, you can.
- If you format a lot of your charts the same way, creating a chart template can save you a lot of work in the future.
- Adding chart labels and a legend makes your chart much easier to follow.
- If your chart data represents a series of events over time (such as monthly or yearly sales), you can use trend line
analysis to extrapolate future events based on the past data.
- Excel 2007 enables you to quickly create and modify common business and organizational diagrams, such as organization
charts and process diagrams.
- If you want to print a chart without printing the rest of the accompanying worksheet, be sure to select the chart before
you open the Print dialog box.
- Sometimes, using a mouse to select a particular chart element is tricky. You may find it easier to use the keyboard to
select a chart element. When a chart is activated, press the up arrow or down arrow to cycle through all parts in the chart.
When a data series is selected, press the right arrow or left arrow to select individual points in the series. Or, select
the chart element by using the Chart Tools Format Chart Elements drop-down control. This control is useful for selecting
chart elements, and it also displays the name of the selected element. Better yet, put this control in your Quick Access
toolbar so it's always visible.
- If you have many charts of the same type to create, create and format the first chart and make a template from that chart
by choosing Chart Tools Design Type Save as Template. When you create your additional charts, use Insert Charts Other Charts
All Chart Types, and then choose your template from the list.
- You can delete all data series from a chart. If you do so, the chart appears empty. It retains its settings, however.
Therefore, you can add a data series to an empty chart, and it again looks like a chart.
- For more control over positioning your chart, press Ctrl while you click the chart. Then use the arrow keys to move the
chart 1 pixel at a time.
- Main Page
- Microsoft Office
- Operating Systems
- Miscellaneous