Charting in Excel
With one detailed prompt, Claude can build a complete sales dashboard inside Excel: a helper column, five PivotTables, five formatted charts and a slicer, laid out on one screen. Here is the exact prompt I used, the sample data to try it on, and why the prompt is written the way it is. ToolClaude in … Read more
A one-page sales dashboard in Excel needs only three things: PivotTables to summarise the data, PivotCharts to show it, and a slicer connected to every chart, so one click on a month updates the whole page. Built withPivotTables, PivotCharts and a slicer ChartsLine, column, bar and pie Works inExcel 2013 and later, Microsoft 365 TimeAbout … Read more
A Gantt chart shows each task of a project as a bar along a calendar. Excel doesn’t have a Gantt chart type, but a stacked bar chart with the first series hidden gives you one in about ten minutes. Chart typeStacked Bar DataTask, Start date, End date, Duration Works inAll versions Video The finished chart … Read more
Organizational Chart in Excel
Comparing actuals with targets is one of the most common charts in reports. Here are four ways to draw it in Excel, from overlapping columns to a chart that colours every month green or red automatically. Chart typesColumn, combo, markers Works inExcel 2013 and later DataMonth, Target, Actual The data Type 1: Thin actual inside … Read more