Creating a Standalone Chart in Microsoft Excel 2007

To create a chart in Microsoft Excel 2007, begin by selecting the data that you wish to plot including any headings. You then have the choice of creating either a stand-alone chart or an embedded chart. To create a stand-alone chart, simply right-click on one of your worksheet tabs and choose Insert. Next, click on the chart icon and click OK. Excel creates a chart using the default chart type.

Having just created a chart, Excel will display three contextual tabs which carry the common heading “Chart Tools”. The contextual tabs consist of Design, Layout and Format. The Design contextual tab enables you to change the chart type and the basic information about the chart such as the underlying data.

The Layout tab provides us with a more intricate level of control over the various components of your chart. For example, by default, Excel adds a legend to each new chart. If a chart has only one series of data, we don’t need a legend to tell us what the chart colours mean. We can therefore click on the Legend drop-down menu and choose None.

The Format contextual tab gives us the most primitive control over your chart elements. It is here that we are able to click on individual items and change them at the object level. In other words, we are working on these elements purely as drawing objects rather than as elements of a chart. However, even at this primitive level, Excel still indicates the relationship between the chart elements and the underlying data. Thus, for example, when an individual data point is highlighted, Excel displays the corresponding worksheet address in the formula bar.

When creating standalone charts, you are not given the option of choosing the chart type during the chart creation process. If you want to change the chart type, you must do so at a later stage by choosing a Chart Type option in the Design contextual menu.

As for the chart sheet which contains the chart, it behaves in much the same way as a worksheet. It can be renamed or deleted by right-clicking the sheet tab and choosing Rename or Delete from the context menu.

The Lastest posts in Software

Music Production With FM Synthesis and Roland Synthesizers
Back in the 1980s, Yamaha came out the DX synthesizers. Hence, the birth of freq...
http://www.bizarticlezone.com/business-computers/software/music-production-with-fm-synthesis-and-roland-synthesizers-4984/

End of Scratches: Xbox 360 Back Up
All the people who has ever owned a console from the first Playstation to the ...
http://www.bizarticlezone.com/business-computers/software/end-of-scratches-xbox-360-back-up-4895/

VST Platinum - Home Music Production Tips
Recording levels are of the utmost importance when you're producing your music. ...
http://www.bizarticlezone.com/business-computers/software/vst-platinum-home-music-production-tips-4836/

Computer Programmers and What it is They Do
Several of todays companies, businesses, and organizations rely largely on compu...
http://www.bizarticlezone.com/business-computers/software/computer-programmers-and-what-it-is-they-do-4787/

Online Wii Games
The Wii was an instant success. This is a gaming system which is completely diff...
http://www.bizarticlezone.com/business-computers/software/online-wii-games-4683/

RegDefense - Truly Efficient and Effective
Getting so much stress from your computer malfunctions? Such as computer freezes...
http://www.bizarticlezone.com/business-computers/software/regdefense-truly-efficient-and-effective-4566/

COMPUTER TOO SLOW? Your Windows operating system may need a clean up to resume its speed
After running their new computer for awhile, users sometimes complain that their...
http://www.bizarticlezone.com/business-computers/software/computer-too-slow-your-windows-operating-system-may-need-a-clean-up-to-resume-its-speed-4551/

A Guide To DJ Music and DJ Mixing Basic Sound Synthesis
Even presently, nearly all synthesizers would give you the monophonic or polypho...
http://www.bizarticlezone.com/business-computers/software/a-guide-to-dj-music-and-dj-mixing-basic-sound-synthesis-4487/

Avoiding Trojan Horse Infections
The Trojan Horse in Greek mythology was the way the Greeks defeated the Trojans ...
http://www.bizarticlezone.com/business-computers/software/avoiding-trojan-horse-infections-4412/

Computer Tech Tools- Here Are Three Everybody Should Have
The question I am asked most is, "Why has my computer slowed down so much?" Whi...
http://www.bizarticlezone.com/business-computers/software/computer-tech-tools-here-are-three-everybody-should-have-4408/