Creating An Embedded Chart in Excel 2007
Before you can create a chart in Microsoft Excel, you must highlight the data that you want to plot. Your selection should also include any relevant headings. Excel allows you to create charts on chart sheets independent of the worksheet containing the data or to embed the chart on the worksheet alongside the data.
To create a chart which is embedded in the worksheet itself, having selected the range of data that you wish to plot, click on the Insert tab of the Excel ribbon and, in the chart section, you will find a series of drop-down menus offering each of the main chart types. Each drop-down reveals a gallery of customised chart types.
Additionally, we can click on the launch button in the bottom right of the Charts group to bring up the Insert Chart dialog box. Here, we are given access to the full range of chart types that Excel has to offer. You will also notice that there is a button which says Set as Default Chart. If you use a particular type more than any other, you can choose that type and click this button so that the next time you create a standalone chart, by right-clicking on a worksheet tab and choosing Insert, the new default chart will be used as the chart type.
When you choose an option from one of the drop-down menus in the Charts group of the Insert tab, Excel creates the embedded chart. The chart is located on the draw layer of Excel which is distinct from the worksheet layer. When you click on a worksheet cell, you are working on the worksheet layer and the chart becomes inactive. When you click on the chart, it is highlighted and you will then be working on the draw layer.
You will notice that whenever the chart is highlighted, Excel displays three contextual tabs called Design, Layout and Format. They contain a series of options specifically related to charts.
In the Design contextual tab, we have the Location Group which contains The Move Chart button. Clicking on this button gives us the option to move the chart to a separate sheet. If you choose the option, Excel creates a new chart sheet and places the chart on it. We can also do the reverse. If you click the Move Chart button once more and click on "Object In...", we can now choose the worksheet that we want to transfer the chart to. When we click OK, Excel embeds the chart in that worksheet and deletes the empty chart sheet.
 1983 The Wizard of Id art IDI CADalyst Computer 4 Pg Ad US $9.99 
|
 1982 Wizard of Id art IDI Computer Graphics System Ad US $9.99
|
 Mini Computer or Laptop Mouse US $4.50
|
 INTERNET MANIA COMPUTER LOVERS MAIL AT SYMBOL MATT SILVER PLATED CUFF LINKS US $3.99
|
 60lb Digital Electronic Scale Price Computing Deli Food Produce Counting Store US $37.95
|
 Fast 7 Google Android 23 PC Tablet PC MID Netbook Computer Touch Screen 4GB US $69.58
|
 PITBULL 60LB DELI RESTAURANT PRICE COMPUTING SCALE AC DC NIB US $49.99
|
 1962 Toshiba Spectrophotometer Color Computer System Ad US $9.99
|
 SEAGATE 100 Gb PC USB External HARD DRIVE Computer File Storage US $23.50
|
 Dell Latitude D620 Laptop Computer Dual Core 16 GHz 2Gb Ram WiFi Dvd Windows 7 US $199.97
|
 Dell 745 Desktop Computer Pc Pentium D Dual Core 28GHz 2GB Ram Dvd Windows US $139.94
|
 Apple Computer Original iMac Introduction Brochure Fold out New cond L03129A US $12.99
|
 BELDEN COAX COMPUTER CABLE Video keyboard RG62A BNC Connectors 100 Length US $54.99
|
 Radix RX1 Handheld Computer w Radix RX HP Printer Radix RX1 ML Optical Loader US $144.99
|
 80 OFF LEATHER I PAD COMPUTER MINI PORTFOLIO KENNETH COLE NWT Reg$200 US $39.99
|
 Lot of 7 packs of Plastik Binder Klips great for around computers New US $14.99
|
 Microfiber Cleaning Cloth 7pieces for eyeglasses camera computer LCD LED US $.99
|
 Mini 4 Port USB 20 Hub Black for Computer Laptop PC US $.01
|
 Custom Gaming Computer 16GB RAM 1600MHz i7 2600K CPU 2 Hard Drives 7 Fans US $2,500.00
|
 JUICY COUTURE 15 Glitter Laptop Computer Case Sleeve Stardust Black NWT US $49.95
|
 FUJITSU LIFEBOOK P1630 TABLET LAPTOP COMPUTER PC TOUCHSCREEN LOW BID US $255.00
|
 66 x 001 LB PRICE COMPUTING DIGITAL SCALE DELI POINT OF SALE POS RETAIL MARKET US $110.00
|
 New Popeye Computer Mouse Pad Mat US $.99
|
 1983 ONE OF FIRST HOME COMPUTERS TEXAS INSTRUMENT AD US $7.99
|
 Apple Computer US $49.99
|
 New 17 Notebook Laptop PC Computer Macbook Carry Bag Case Shoulder Strap US $16.99
|
 Nice Laptop Mice Pad Computer Optical Mouse Pad Mousepad Mouse Mat New US $.99
|
 Dell Latitude D620 LAPTOP 2GB WINDOWS 7 COMPUTER WIRELESS WIFI CDRW DVD NOTEBOOK US $194.95
|
 HP DC5100 DESKTOP PC P4 28 GHZ COMPUTER WIN XP PRO SP3 CDRWDVD FREE SHIPPING US $57.00
|
 NEW Mini wireless Mic Microphone for Computer PC laptop NOTEBOOK US $3.95
|
 BRAND NEW KINDLE FIRE PROTECTIVE COVER COMPUTER TABLET Stands up US $5.99
|
 Hp Compaq DC5000 SFF P4 28 Ghz Computer w 256 MB RAM CD ROM Floppy US $49.99
|
 HP Mini 210 Netbook Laptop Computer 210 1018CL Lot with Bag Case Mouse Adapter US $155.00
|
 Kraftwerk Numbers Computer Love Electro Funk 45 US $4.95
|
 NEC MT1045 169 HD HOME THEATER COMPUTER PROJECTOR US $46.50
|
 NEW OCTA CORE Gaming Computer 16GB Ram 1600 Fx 8150 8 Core48ghz AFX 6870 US $910.00
|
 Black Cat Face Slim Anti slip Mouse Pad Mouse Mice Computer PC Mat Mousepad Cool US $1.00
|
 NEW Sony DG90P DAT Digital Audio Tape Computer Grade Professional Media 180 min US $8.99
|
 INFOCUS LP335 169 HD DLP HOME THEATER COMPUTER PROJECTOR WITH DIGITAL HD INPUT US $76.00
|
 KRAFTWERK COMPUTER WORLD numbers BREAKS 7 trks US $7.95
|
Related posts
Tagged with: charts • computer software • Computers • Excel 2007 • Excel 2007 training courses • Microsoft Excel 2007 • Microsoft Office 2007 • software programs • spreadsheets • training • tutorial