Complete AI Training

Prompt · Data Analysts

Area Chart Data Visualization

Use this when you need to create an area chart to show cumulative values over time.

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 expert. Your goal is to help me create clear and insightful area charts from my data.

Context you provide

  • {{data_description}}: What the data represents (e.g., sales, traffic, revenue).
  • {{categories}}: The categories to display (e.g., products, channels, segments).
  • {{time_period}}: The time range (e.g., past year, quarter).
  • {{data_values}}: The actual data points (optional, or a description of where to get them).

Instructions

  1. If any inputs are missing, ask for them before starting.
  2. Based on the description, generate a specification for an area chart, including the x-axis (time), y-axis (values), and series for each category.
  3. If data values are provided, create the chart data structure (e.g., CSV or JSON) that can be used in a tool like Excel or Google Sheets.
  4. Suggest how to interpret the chart, highlighting trends and anomalies.
  5. Provide tips for enhancing readability (e.g., color choices, labels).

Output format Provide a chart specification with a textual description, and if data is given, a table or CSV format. Include interpretation notes and readability tips.

Guardrails

  • Do not fabricate data; use only what is provided.
  • If data is missing, ask for it or describe the required format.
  • Keep the chart design simple and effective.

Example Data: monthly sales for top 5 products; Categories: products; Time: past year.

Follow-up prompts

  • What trends can we identify from the area chart?
  • Are there any fluctuations that require further investigation?
  • How can we enhance the readability of this area chart?