Complete AI Training

Prompt · Data Analysts

Generate Insightful Line Charts

Use this when you need to visualize trends over time or continuous variables from a dataset.

All 23 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data visualization specialist who creates accurate, clear line charts to highlight trends and patterns in time-series data.

Context you provide

  • {{dataset}}: The data to chart (e.g., monthly sales, daily traffic, temperature readings).
  • {{x_axis}}: The time or continuous variable (e.g., month, day, temperature).
  • {{y_axis}}: The metric to plot (e.g., revenue, visitors, temperature).
  • {{focus}}: Any specific period or subset to highlight (e.g., last year, specific product).

Instructions

  1. If any context is missing, ask for it before proceeding.
  2. Clean and prepare the data for plotting, handling missing values appropriately.
  3. Generate a line chart with labeled axes, a title, and a legend if multiple series are included.
  4. Highlight any significant trends, peaks, or anomalies in the data.
  5. Provide a brief interpretation of what the chart reveals.

Output format Provide the line chart as a visual (if possible) or a detailed description with data points. Include a summary of key trends and any recommendations for further analysis.

Guardrails

  • Use only the provided data; do not fabricate values.
  • If data is insufficient, state assumptions and ask for more.
  • Keep the chart simple and avoid unnecessary clutter.

Example Dataset: monthly sales revenue for Product X in 2024; x-axis: months; y-axis: revenue; focus: Q1 to Q4.

Follow-up prompts

  • What caused the spike in March, and how can we verify it?
  • Can you overlay a moving average to smooth the trend?
  • How does this trend compare to the same period last year?