josephm8的部落格

Once you have a PivotTable created, you can devise a PivotChart. You can likewise fabricate a PivotChart from scratch, but using an extant PivotTable makes the job much easier.

To originate a PivotChart, start on the Excel record you created closer and sound location in the PivotTable. The PivotTable toolbar should set off. Click the Chart Wizard control from the PivotTable toolbar or from the Standard Toolbar.

A new sheet of paper will seem that shows your PivotTable facts as symptomless as the buttons you utilized in the Layout option. The PivotChart will have the aforementioned design as the PivotTable you're exploitable from, so you'll poorness to have the PivotTable laid out appropriately.

You will data formatting the PivotChart in the aforementioned way you formatting any another chart, bar that you'll call for to animal skin the buttons related next to your PivotTable. The atlas will unconsciously update if you modification the aggregation demonstration on the chart, but you cannot reformat the array on the fly when the buttons are obscured.

To hide from view the buttons on the PivotChart, prime the PivotChart pull-down card on the PivotTable Toolbar, and select "Hide PivotChart Field Buttons" from the menu. This is a toggle, so a checkmark will occur when this bill of fare pronouncement is progressive. To fair the buttons again, choice "Hide PivotChart Field Buttons" once again from the aforementioned bill.

The PivotChart is freshly a graphic representation of the notes in a PivotTable, so changes you generate in the PivotTable will be echoic in the PivotChart. In the PivotTable we made, we didn't use any functions, another than tally values together, but PivotTables can judge any functions or formulas. You can sort, use functions, add and fish out fields, and hide and express items, purely as you would in a rhythmical table.

You can too enter a PivotChart into a sheet of paper. To do this, quality the PivotChart by clicking everywhere on it. Right-click the atlas to pull-up the contextual carte and quality "Location." This will get underway a talking box that allows you to stipulate a new worksheet, or an alive sheet of paper in your book. The PivotChart (minus the background piece of paper) will be in the entity you've designated.

One linguistic unit of carefulness when valid beside a PivotChart: you can respite the bond linking a PivotTable and a PivotChart if you aren't discreet when emotional comedian about in the PivotChart. When this happens, you will have to remake the PivotTable, consequently creation the PivotChart. The quality way to stay away from 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 hazard of unconsciously creating a lot of work for yourself.