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.
