Prompt · Data Analysts
Area Chart Data Visualization
Use this when you need to create an area chart to show cumulative values over time.
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 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
- If any inputs are missing, ask for them before starting.
- Based on the description, generate a specification for an area chart, including the x-axis (time), y-axis (values), and series for each category.
- 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.
- Suggest how to interpret the chart, highlighting trends and anomalies.
- 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?