How to create a Pivot Table chart
OVERVIEW
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.
Related Articles
How to create a Pie chart
OVERVIEW A pie chart is a circular graphical representation used to display data as a proportional distribution of categories. The chart resembles a pie, with each category represented as a slice, where the size of each slice corresponds to the ...How to create a Table chart
OVERVIEW A table chart, also known as a data table or tabular chart, is a visual representation of data in a structured tabular format. It presents data in rows and columns, similar to a spreadsheet or database table. Table charts are commonly used ...How to create a Bar chart
Overview A Bar Chart compares metrics from different categories using bars. Bar lengths are used to indicate the magnitude of each value and colour is used to differentiate groups. Creating a Bar Chart Step 1: Select the "Charts" tab in the top bar, ...How to create a Big Number chart
OVERVIEW Showcases a single metric front-and-center. Big number is best used to call attention to a KPI or the one thing you want your audience to focus on. The intention of a big number chart is to visually highlight and draw attention to important ...How to create a Time-Series Bar chart
OVERVIEW A time-series bar chart, also known as a timeline bar chart, is a type of data visualization that combines the elements of a bar chart with a time axis. It is used to display and compare the values of different categories or variables over a ...