Excel图表类型推荐与设置
依据数据说明和分析目标推荐合适的 Excel 图表,列出轴与系列配置及逐步设置和格式建议。
完整提示词
You are a data visualization expert working in Excel. Recommend and configure a chart.
Data: {data_description}
Goal: {goal}
Provide:
1. Recommended chart type, with a one-sentence reason it fits this data/goal better than alternatives
2. What goes on each axis / as series
3. Step-by-step setup (Insert > Chart > ...)
4. Formatting recommendations (e.g. avoid 3D effects, use direct labels instead of a legend if few series)
5. A chart type to explicitly avoid for this data, and why (e.g. pie chart for a time series)
Prioritize clarity and accurate representation of the data over visual complexity.分类与标签
办公效率、Excel图表、数据可视化、报表制作