In the daily work, we may encounter the need to divide the data of several provinces into a chart, in many provinces, manual operation is undoubtedly a waste of time. This is accomplished by using the PivotTable report Filter page + record macro.
Data sources such as: 650) this.width=650; "Src=" Https://s3.51cto.com/wyfs02/M02/8C/EF/wKiom1h-LlzgN8e4AAB00fAuSRg970.png-wh_ 500x0-wm_3-wmp_4-s_2358273423.png "title=" 2.png "alt=" Wkiom1h-llzgn8e4aab00fausrg970.png-wh_50 "/>
1, set up a pivot table, the pivot table format to the form we want, the representative of a column in the filter items;
650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M02/8C/EF/wKiom1h-Lo7gr5RoAAA6XFUrg5Q173.png-wh_500x0-wm_ 3-wmp_4-s_2009201008.png "title=" 3.png "alt=" Wkiom1h-lo7gr5roaaa6xfurg5q173.png-wh_50 "/>
2. Click PivotTable, Options-options-right Triangle-Show Report Filter page-Select the Representative field, which is automatically generated;
650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M00/8C/EF/wKiom1h-LuyAFTJ4AACMs3a7IGY445.png-wh_500x0-wm_ 3-wmp_4-s_955140308.png "title=" 4.png "alt=" Wkiom1h-luyaftj4aacms3a7igy445.png-wh_50 "/>
3, use Shift key to select all Provinces sheet tab, paste all the pivot table values, on the first sheet page to record a macro ; Click Development tools-Record Macro-enter shortcut-start recording: Check A4-D6 data-Insert Line chart-right-select data-Change absolute reference of Reference Data section to relative reference-save-stop recording;
4, to other sheet page press the shortcut key, you can implement other sheet pages automatically insert the same format of the table.
650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/8C/EF/wKiom1h-MGrh4VBUAACIqXq9LUg926.png-wh_500x0-wm_ 3-wmp_4-s_3897463754.png "style=" Float:none; "title=" 5.png "alt=" Wkiom1h-mgrh4vbuaaciqxq9lug926.png-wh_50 "/>
650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/8C/EC/wKioL1h-MGvRM4gbAACyjmawdqI731.png-wh_500x0-wm_ 3-wmp_4-s_1424375496.png "style=" Float:none; "title=" 6.png "alt=" Wkiol1h-mgvrm4gbaacyjmawdqi731.png-wh_50 "/>
Excel beginner, the daily encounter of the newly learned Excel tips are written here ~
This article is from the "12522101" blog, please be sure to keep this source http://12532101.blog.51cto.com/12522101/1892741
excel-how to make a chart in batches of the same form