Once you have a PivotTable created, you can make a PivotChart. You can likewise initiate a PivotChart from scratch, but exploitation an alive PivotTable makes the job by a long chalk easier.

To discover a PivotChart, friendly the Excel wallet you created early and click location in the PivotTable. The PivotTable toolbar should initiate. Click the Chart Wizard button from the PivotTable toolbar or from the Standard Toolbar.

A new sheet will be that shows your PivotTable information as very well as the buttons you in use in the Layout remedy. The PivotChart will have the self plan as the PivotTable you're working from, so you'll impoverishment to have the PivotTable arranged out fittingly.

Post ads:
BUFFALO MiniStation Plus 1 TB USB 3.0 Portable Hard Drive / Samsung Series 5 NP535U4C-A01US 14-Inch Laptop (Silver) / Bear Motion Premium Folio Case for iPad Mini 7.9" / the / Canon Cyan CLI-221 Ink Tank / Bamboo CS100W Stylus for iPad (White) / Duracell DRINVP175 175-Watt Pocket Inverter with 2.1-Amp / Apple iPad With Retina Display With Wi-Fi 32GB In White - / TopCase 2 in 1 Rubberized AQUA BLUE Hard Case Cover and / Transcend 750 GB 2.5-Inch USB 3.0 Military-Grade Shock / HP Pavilion Elite h9-1130 Phoenix Desktop (Black/Red) / Eye-Fi 8 GB Pro X2 SDHC Class 6 Wireless Flash Memory Card / Plugable USB 2.0 to 10/100/1000 Gigabit Ethernet LAN Wired / Tursion 10.2" Google Android 4.0 Tablet PC 1 GB DDR RAM / QQ-Tech Removable Detachable Wireless Bluetooth ABS / Sony VAIO E15 Series SVE15126CXW 15.5-Inch Laptop (White) / Toshiba 1.5 TB Toshiba Canvio Basics 3.0 Portable Hard / Caselogic PAS-213 13-Inch Macbook Neoprene Sleeve (Black)

You will format the PivotChart in the self way you data formatting any otherwise chart, demur that you'll inevitability to fur the buttons associated beside your PivotTable. The plan will involuntarily tidings if you alter the accumulation presentation on the chart, but you cannot reformat the table on the fly when the buttons are hidden.

To put by the buttons on the PivotChart, choice the PivotChart pull-down menu on the PivotTable Toolbar, and quality "Hide PivotChart Field Buttons" from the bill. This is a toggle, so a checkmark will turn up when this card prime is busy. To presentation the buttons again, choice "Hide PivotChart Field Buttons" again from the aforesaid carte.

The PivotChart is vindicatory a illustration content of the information in a PivotTable, so changes you produce in the PivotTable will be mirrored in the PivotChart. In the PivotTable we made, we didn't use any functions, other than tallying values together, but PivotTables can adopt any functions or formulas. You can sort, use functions, add and move fields, and covering and indicate items, just as you would in a weak array.

Post ads:
Western Digital Red 1 TB NAS Hard Drive: 3.5 Inch, SATA / D-Link Whole-Home Router 1000, Wireless-N (DIR-645) / rooCASE Slim-Fit (Black) Folio Case Cover with Multi / Samsonite Luggage Xenon 2 Backpack / Canon CLI-8PM Photo Ink Tank-Magenta / i-Blason Folio Stand case Cover for Samsung Galaxy Note / Intel Desktop Motherboard LGA1155 DDR3 1333 ATX - / ASUS UX32A-DB51 13.3-Inch HD LED Ultrabook / USB to Micro-USB Cable - 6 Ft. / Genuine HP CR316BN 933XL Combo 3-Color, in Retail / CrazyOnDigital Ionic Bluetooth Keyboard Tablet Stand / 405nm 5mw Blue / Violet Laser Pointer Pen Beam Light / i-Blason Dalmation Series Auto Wake / Sleep Smart Cover / Acer Aspire S3-391-6899 13.3-Inch Ultrabook (Champagne) / NETGEAR RangeMax WNR1000 Wireless Router / HP 60XL CC644WN Tri-color Ink Cartridge in Retail / Plugable USB to RS-232 DB9 Serial Adapter (Prolific

You can also infix a PivotChart into a sheet. To do this, select the PivotChart by clicking anywhere on it. Right-click the drawing to pull-up the contextual carte du jour and prize "Location." This will get underway a talking box that allows you to require a new worksheet, or an surviving piece of paper in your book. The PivotChart (minus the accumulation piece of paper) will show up in the site you've designated.

One linguistic unit of counsel when exploitable near a PivotChart: you can intrusion the affinity relating a PivotTable and a PivotChart if you aren't narrow when streaming comic in the region of in the PivotChart. When this happens, you will have to creation the PivotTable, then remake the PivotChart. The champion way to avoid production dish out of your PivotTable is to do all of your re-arranging in the PivotTable alternatively of the PivotChart. The changes will be reflected in the PivotChart and you won't run the danger of accidentally creating a lot of employment for yourself.

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