Once you have a PivotTable created, you can turn out a PivotChart. You can also construct a PivotChart from scratch, but victimisation an in existence PivotTable makes the job noticeably easier.

To fabricate a PivotChart, unfold the Excel file you created in advance and click location in the PivotTable. The PivotTable toolbar should spark off. Click the Chart Wizard fastening from the PivotTable toolbar or from the Standard Toolbar.

A new sheet of paper will turn up that shows your PivotTable information as asymptomatic as the buttons you utilized in the Layout alternative. The PivotChart will have the identical plan as the PivotTable you're employed from, so you'll impoverishment to have the PivotTable laid out fittingly.

Post ads:
Intel Core i3-3220 Dual-Core Processor 3.3 Ghz 3 MB Cache / 3-Year Computer Accident Protection Protection Plan / Lenovo ThinkPad 1838-22U 10.1" 16GB Tablet (No Stylus) / Canon 4530B001 PGI-225 Pigment Black Ink Tank / Logitech 720p Webcam C905 / Sony VAIO E14 Series SVE14122CXW 14-Inch Laptop (White) / ArmorSuit MilitaryShield - Samsung Galaxy Tab 2 10.1 / HDE Hard Cover Case with Keyboard for 7" Tablet - Pink / 3M Streaming Projector Powered by Roku (SPR1000) / Sony VAIO E15 Series SVE15126CXS 15.5-Inch Laptop (Silver) / QQ-Tech Removable Detachable Wireless Bluetooth ABS / Toshiba Z935-P300 Portege Ultrabook 13.3" Laptop - 4GB / SanDisk Ultra 16 GB microSDHC Class 10 UHS-1 Memory Card / Brother TN-115BK High Yield Black Toner Cartridge for / G-Technology G-DRIVE Mobile USB 1TB 5400RPM Portable / Cables To Go 26911 DVI-D Male/Male Dual Link Digital Video / SanDisk 32GB Extreme Pro CF memory card - UDMA 90MB/s 600x

You will formatting the PivotChart in the selfsame way you data format any different chart, apart from that you'll condition to obscure the buttons related beside your PivotTable. The chart will as a reflex action intelligence if you shift the facts flourish on the chart, but you cannot reformat the array on the fly when the buttons are clandestine.

To stow the buttons on the PivotChart, select the PivotChart pull-down card on the PivotTable Toolbar, and prize "Hide PivotChart Field Buttons" from the bill. This is a toggle, so a checkmark will become visible when this card choice is involved. To trumpet blast the buttons again, quality "Hide PivotChart Field Buttons" once again from the same bill.

The PivotChart is honourable a graphic interpretation of the information in a PivotTable, so changes you make in the PivotTable will be echolike in the PivotChart. In the PivotTable we made, we didn't use any functions, remaining than tally values together, but PivotTables can adopt any functions or formulas. You can sort, use functions, add and erase fields, and fur and festival items, in recent times as you would in a weak table.

Post ads:
Corsair Vengeance Blue 8 GB (2X4 GB) PC3-12800 1600mHz / Lite-On Super AllWrite 24X SATA DVD+/-RW Dual Layer Drive / Acase CLEAR Screen Protector for iPad 4 / iPad 3 / The New / Epson DURABrite T069120-BCS Ultra 69 Standard-capacity / Brother MFCJ6710DW Business Inkjet All-in-One Printer with / Transcend Information JetFlash 700 - 64 GB USB 3.0 Flash / TP-Link TL-WN951N 300Mbps Wireless N PCI Adapter / SanDisk 32GB MicroSDHC High Speed Class 4 Card with / HP Pavilion p6-2350 Desktop (Black) / Dell Latitude D630 14.1-Inch Notebook PC - Silver / SanDisk Extreme Pro 64 GB SDXC Class 10 UHS-1 Flash Memory / 5 in 1 Card Reader for Apple iPad iPad 2 The New iPad 3 / Genius SW-G2.1 1250 2.1 Speaker System / Kingston Hyper X Blu 8 GB (2x4GB Modules) 1600MHz DDR3 / Superb Choice 9-Cell Replacement Battery for Dell Inspiron / Dell 745 Optiplex Tower Computer, Featuring Intel's / Belkin 8-by-9-Inch Mouse Pad (Black)

You can as well infix a PivotChart into a piece of paper. To do this, select the PivotChart by clicking everywhere on it. Right-click the illustration to pull-up the contextual carte and superior "Location." This will unseal a talking box that allows you to insist on a new worksheet, or an existing piece of paper in your book. The PivotChart (minus the collection sheet) will happen in the entity you've designated.

One expression of forewarning when in a job beside a PivotChart: you can fracture the human relationship betwixt a PivotTable and a PivotChart if you aren't diligent when wiggly comic circa in the PivotChart. When this happens, you will have to creation the PivotTable, afterwards remake the PivotChart. The second-best way to hedge fashioning dish out of your PivotTable is to do all of your re-arranging in the PivotTable as an alternative of the PivotChart. The changes will be reflected in the PivotChart and you won't run the risk of accidentally creating a lot of hard work for yourself.

lowksie 發表在 痞客邦 PIXNET 留言(0) 人氣()