Add a normal chart by using addChartInPixel method of IShapes interface.The below mentioned steps explain how to create a pivot chart: The below image displays a pivot chart with legend, axis and value field buttons. You can configure whether to display the legend, axis, value field buttons or expanding or collapsing entire field buttons by using the getPivotOptions method. When a field button is clicked, its filter pane appears. It helps you to sort and filter pivot chart's underlying data.Įxcel files with pivot charts can be loaded, modified and saved back to Excel. The pivot table fields are displayed on a pivot chart as buttons. Like a normal chart, the pivot chart displays data series, categories, legends, data markers and axes. You can change the titles, legend placement, data labels, chart location etc.Ī pivot chart is interactive as it reflects the changes made in its associated pivot table. Pivot chart represents the data of associated pivot table in a chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |