A pivot chart is a type of data visualization tool that combines the features of a pivot table and a chart. It allows for the dynamic analysis and presentation of data in a graphical format. Pivot charts are commonly used in spreadsheet software, such as Microsoft Excel, to summarize and display complex data sets in a more understandable and visually appealing manner.
Pivot charts are particularly useful when dealing with large datasets or when there is a need to analyze data from multiple perspectives. They allow users to quickly summarize and visualize data in a flexible and interactive manner, making it easier to identify trends, patterns, and relationships within the data. Pivot charts provide a powerful tool for data exploration, reporting, and decision-making in various domains, including business, finance, and data analysis.
CREATE A PIVOT TABLE CHART
Step 1: Access the Charts Section,
> On the top of the page, select the "Charts" option.
Step 2: Create a New Chart,
> On the Charts page, click on the "+Chart" button to initiate the creation of a new chart.
Step 3: Select a Dataset,
> In the "Dataset" section, click on the dropdown menu and select the dataset you want to use for your Time-Series Area chart.
Step 4: Select "Pivot Table Chart" as the Chart Type.
Step 5: Specify Your Metrics,
> Go to the "Metrics" section and click on the "Add" button.
> From the dropdown menu, select the metric(s) you want to display in your pivot table.
Step 6: Define Your Columns,
> In the "Columns" section, click the "Add" button.
> From the dropdown menu, select the column(s) you want to show in your pivot table. These will form the columns in your pivot table.
Step 7: Define Your Time Range,
> Set the range for your data in the "Time" section.
> This can be done by selecting the start and end dates, or by defining a relative time range, such as "Last Week" or "Last 30 days".
Step 8: Customize Your Pivot Table,
> Explore the available customization options in Pluto Insights.
> You can adjust the sorting, add color coding, or make other adjustments to make your pivot table more insightful.
Step 9: Run Query,
> Click the "Run Query" button to generate your pivot table based on the parameters you've set.
Step 10: Save Your Pivot Table,
> Click the "Save" button to save your pivot table.
> You'll be prompted to provide a name for your table and, if you wish, a description.
> Click "Save" again.
Your pivot table will now be available under the "Charts" section for future reference.