Choose the Right Chart for the Business Question

What You Will Learn

You will learn how to ask Gemini which visual format best answers a business question: line chart, bar chart, scatter plot, waterfall, heatmap, or table.

Required Dataset

Use the FinanceCo_PL_Dataset.

Use the tab:

Monthly_PL

Create three new tabs:

Chart_Selection_Practice

Chart_Recommendations

Chart_Check

Before You Start

Copy relevant fields from Monthly_PL into Chart_Selection_Practice, including Month, Business Unit, Region, Product Line, Revenue, EBITDA, Headcount, Revenue per Employee, and EBITDA Margin %.

Step-by-Step Instructions

Step 1. Ask Gemini to recommend chart types

Use this prompt:

Act as a data visualization coach.

Use the Chart_Selection_Practice tab.

Objective: Recommend the best chart type for common business questions.

Consider line charts, bar charts, scatter plots, waterfall charts, heatmaps, and tables.

For each recommendation, explain the business question it answers, the data needed, and the main caveat.

Step 2. Match chart type to question

Use these simple rules:

Line chart: trend over time

Bar chart: compare categories

Scatter plot: relationship between two metrics

Waterfall chart: explain movement from one value to another

Heatmap: find patterns across two dimensions

Table: show exact values, exceptions, or actions

Step 3. Create chart-ready data

In Chart_Recommendations, create small data sections for:

Monthly Revenue and EBITDA trend

Revenue by Business Unit

Revenue per Employee vs. EBITDA Margin %

EBITDA bridge

EBITDA Margin by Region and Product Line

Management exception list

Ask Gemini which chart fits each section and why.

Step 4. Ask Gemini to improve chart titles

Use this prompt:

Rewrite these chart titles as insight-oriented titles. Keep them accurate, concise, and not overstated.

Expected Result

You should have a chart recommendation guide that connects each business question to the best visual format and documents why that format is appropriate.

Check Your Work

Confirm that each chart answers a clear question, the data structure supports the chart, and Gemini’s recommendation does not overstate what the visual proves.

Optional Extension

Ask Gemini:

Review the Chart_Recommendations tab and identify charts that should be simplified, replaced with tables, or split into separate visuals.

How to get started

1

arrow-down-blue

Tell us about your project

2

arrow-down-blue

Interview candidates

(We’ll provide bios within 48 hours on average)

3

Select your consultant and start work

Find a Consultant

or email us at: [email protected]