How do I create a chart from a results set in Ask Your Data?

In Ask Your Data, you can easily convert your data tables into visual charts using the Chart Builder. Select from chart types like Bar, Pie, Line, or Scatter, then choose the relevant data types to generate visualizations that highlight trends and relationships. You can also zoom into specific areas of your chart for a closer look at your data insights.

Note: Sub-account administrators can use Ask Your Data (AYD) directly within their own sub-accounts, where AYD is scoped to display only the data relevant to that specific sub-account.

How do I create a chart from a results set in Ask Your Data?

How do I create a chart from results set in Ask Your Data?

1. View Data Results Table

Data results display in Table View by default.
View Data Results Table

2. Open Chart Builder

To view results set in a chart format, click the Chart Builder tab.
Open Chart Builder

3. Select Chart Type

Select your chart type from the following options: Bar Chart, Pie Chart, Line Chart, or Scatter Chart. Some charts may not be available based on the data in the results set.
Select Chart Type

4. Select Data Types

Data types are presented as temporal, numerical or categorical data types. Select the applicable data types and click the Generate button. Some data types may not be available based on the chart selected.
Select Data Types

5. Bar Chart

The charts then display as your selected visualization. Bar Charts present categorical data.
Bar Chart

6. Pie Chart

Pie Charts presents the data as parts of a whole.
Pie Chart

7. Line Chart

Line Charts show changes in the data types over time.
Line Chart

8. Scatter Plot

Scatter Plots show the relationship between data points.
Scatter Plot

9. Focus on Highlighted Section

To focus on a specific highlighted section on the chart, click and drag the area to zoom in on.
Focus on Highlighted Section

10. View Focused Area

The selected area will be displayed on the chart.
View Focused Area
This guide covered how to create a chart from a results set in Ask Your Data.