Excel 2007 – On learning this time we will discuss various PivotTable advanced techniques that will improve your skills. Do not miss these 3 videos …. You will be guided to begin to make graphs or charts using pivottabel. You can also display these charts side by side with pivottabelnya. You can also specify the type garafik in making charts of these pivottabel. You can also instantly create a PivotChart from the data in Microsoft Excel sheet that we make. After you finish creating PivotChart as you want, you also can specify where the chart or graph that you created to place the new sheet.
Advanced Techniques Advanced PivotTable
Once you can make a chart or graph, you also change the type of graph / chart from pivottabel you use this feature change the chart type menu. In addition you can also sort the data in pivottchart you want, whether you want to sort the data from the lowest data samapai highest or vice versa. Description or lengen key in PivotChart helpful for you in understanding the graphs that you create. For graphs that we make it easy to read and membarikan appropriate information content of existing data, then you can adjust the position of the key lengen making it easier to read the data.
If you create a PivotChart data directly from excel, then the chart itself will form a new sheet. Well if you want to display data from your table adjacent to the PivotChart that you created, then you can use the menu layout, and select the data table option. Once you have completed setting up of the chart or PivotChart view that you created, you can set the display printing or print preview to print. In addition, you can add headers and footers from the title of your chart will be printed. Now for the more details you can see in the video to learn the following, in addition you will see some other material. okay … congratulations to learn …