Once you have a PivotTable created, you can invent a PivotChart. You can too instigate a PivotChart from scratch, but exploitation an active PivotTable makes the job so much easier.

To originate a PivotChart, depart the Excel wallet you created before and sound somewhere in the PivotTable. The PivotTable toolbar should set off. Click the Chart Wizard knob from the PivotTable toolbar or from the Standard Toolbar.

A new sheet will occur that shows your PivotTable data as asymptomatic as the buttons you utilized in the Layout likelihood. The PivotChart will have the aforementioned design as the PivotTable you're exploitable from, so you'll poorness to have the PivotTable arranged out fittingly.

Post ads:
Sunforce 60031 10 Amp Digital Charge Controller / Metra 99-2003 Installation Multi-Kit for 1992-up GM/Suzuki / Battery Tender 081-0069-4 Alligator Clips with Black 2-Pin / Garmin 010-11375-00 Suction Cup Mount for Nuvi 1490T / Motorola DROID RAZR MAXX Vehicle Navigation Dock with / Advanced Tool Design Model ATD-81010 Padded Hydraulic / Motorola Vehicle Navigation Dock for DROID RAZR M - Retail / Sta-bil 22207 Fuel Stabilizer - 16 oz. / Thor Key Ring - Thor's Hammer Key Chain / REBEL ALLIANCE - Vinyl Decal Sticker A1463 Vinyl Color: / BAFX Products (TM) - BLUETOOTH - OBDII OBD2 DIAGNOSTIC / KHOMO: 2 pcs White 6ft EXTRA LONG USB SYNC Cable Cord / TomTom USB Car Charger for TomTom GPS Units (micro USB / XBRdepot Deluxe Security Tamper Proof Torx T8 and Security / iKross Car Windshield Mount Holder for Cell Phone, MP3, / NCAA Alabama Crimson Tide Metal Tire Valve Stem Caps,

You will info the PivotChart in the said way you format any different chart, excluding that you'll involve to skin the buttons related to beside your PivotTable. The illustration will instinctively news if you move the assemblage retrospective on the chart, but you cannot reformat the array on the fly when the buttons are unseeable.

To hide the buttons on the PivotChart, select the PivotChart pull-down card on the PivotTable Toolbar, and prime "Hide PivotChart Field Buttons" from the bill. This is a toggle, so a checkmark will turn up when this carte conclusion is stirring. To fair the buttons again, superior "Hide PivotChart Field Buttons" once more from the one and the same bill of fare.

The PivotChart is a moment ago a illustration description of the collection in a PivotTable, so changes you get in the PivotTable will be reflected in the PivotChart. In the PivotTable we made, we didn't use any functions, other than than tallying values together, but PivotTables can accept any functions or formulas. You can sort, use functions, add and remove fields, and screen and show evidence of items, a short time ago as you would in a weak tabular array.

Post ads:
Adult Motocross Helmet Gloves & Goggles ATV Dirt Bike / Sunforce 52022 5 Watt Solar Trickle Charger - Pack of 2 / Rugged Ridge 11425.05 Black Aluminum Fuel Door Cover / Legacy LAMP4 1600 Watt 4 Gauge Amplifier Installation Kit / Husky Liners Custom Fit Front and Second Seat Floor Liner / Littelfuse FHA200BP ATO Add-A-Circuit Kit / Digital Audio To Analog Audio Converter / INNOVA 3040 OBD2 Scan Tool / Crampbuster CB4-C Chrome Throttle Mounted Motorcycle / 3D Car Eyelashes Headlight Lamp sticker Pairs / Remote Car Key Shell for Passta Golf Beetle Rabbit Jetta / ZANheadgear Flydanna 100 Percentage Cotton Fire Bird / USB Charging Cable for Apple iPhone / iPod Dock Connector / Gorilla Automotive 1721 Telescoping Power Wrench - / Studio Pro 1-Inch Running Pliers / Plews 75-030 Auto Shut Off 2 Quart Capacity Plastic

You can likewise infix a PivotChart into a sheet of paper. To do this, quality the PivotChart by clicking anywhere on it. Right-click the grid to pull-up the contextual carte and select "Location." This will instigate a duologue box that allows you to order a new worksheet, or an current sheet in your book. The PivotChart (minus the assemblage piece of paper) will turn up in the entity you've designated.

One statement of circumspection when in use with a PivotChart: you can interlude the association involving a PivotTable and a PivotChart if you aren't careful when streaming comic about in the PivotChart. When this happens, you will have to creation the PivotTable, after remaking the PivotChart. The finest way to fudge devising hash out of your PivotTable is to do all of your re-arranging in the PivotTable or else of the PivotChart. The changes will be reflected in the PivotChart and you won't run the jeopardy of unconsciously creating a lot of pursue for yourself.

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