How to create a Pivot Table chart

How to create a Pivot Table chart


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.


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 ...