Microsoft Office Tutorials and References
In Depth Information
Turning Data into a Chart
To learn more about fine-tuning the look and feel of a chart, see “Advanced Chart Formatting
Options” on page 442.
One final option allows you to change the location of a chart. Click Move Chart (the
rightmost command on the Design tab) to see the dialog box shown here. You can position the
chart on its own sheet or as an object that floats on a worksheet—typically the same one
containing your source data.
INSIDE OUT Change a chart’s location to suit the task at hand.
It’s perfectly acceptable to move a chart to make it easier to work with. As you change
the data in a table, for example, you might want to see your changes reflected in real
time in a linked chart. In that scenario, move the chart to the current worksheet and
position the chart object alongside the data you’re entering or editing. When you’ve
polished the chart to perfection, move it to its own chart sheet and give the sheet a
descriptive name. That makes finding the chart easier so you can use it in a Word
document or a PowerPoint presentation later.
Turning Data into a Chart
In this whirlwind tour of the charting features in Excel, we focus on the nuts and bolts of
actually building a chart. If you’re looking for detailed explanations of the concepts behind
turning information into graphics, we highly recommend starting with Edward Tufte’s
seminal work on the subject (see www.edwardtufte.com ). And because space is limited, we can
only dive just below the surface in showing you the many options available when you
create and customize Excel charts. For a much more complete picture, we recommend
Microsoft Excel 2010 Inside Out , by our colleagues Mark Dodge and Craig Stinson (Microsoft
Press, 2010).
Search JabSto ::




Custom Search