Prompt · Data Analysts
Generate Insightful Line Charts
Use this when you need to visualize trends over time or continuous variables from a dataset.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- 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
- If any context is missing, ask for it before proceeding.
- Clean and prepare the data for plotting, handling missing values appropriately.
- Generate a line chart with labeled axes, a title, and a legend if multiple series are included.
- Highlight any significant trends, peaks, or anomalies in the data.
- 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?