Click on the series you want as a line → right-click → "Change Series Chart Type"

In the dialog, set Series 2 to Line

Check "Secondary Axis" for the line series

Format both axes – adjust scale min/max so both series display cleanly; then remove excess gridlines, format the line with a contrasting colour, and add data labels selectively

Select your two data series and insert a clustered column chart

In the dialog, set Series 2 to Line

Check "Secondary Axis" for the line series

Format both axes – adjust scale min/max so both series display cleanly; then remove excess gridlines, format the line with a contrasting colour, and add data labels selectively

Select your two data series and insert a clustered column chart

Click on the series you want as a line → right-click → "Change Series Chart Type"

Check "Secondary Axis" for the line series

Format both axes – adjust scale min/max so both series display cleanly; then remove excess gridlines, format the line with a contrasting colour, and add data labels selectively

Select your two data series and insert a clustered column chart

Click on the series you want as a line → right-click → "Change Series Chart Type"

In the dialog, set Series 2 to Line

Format both axes – adjust scale min/max so both series display cleanly; then remove excess gridlines, format the line with a contrasting colour, and add data labels selectively

Select your two data series and insert a clustered column chart

Click on the series you want as a line → right-click → "Change Series Chart Type"

In the dialog, set Series 2 to Line

Check "Secondary Axis" for the line series

Format: remove legend, remove axis, increase gap width to 15–20%

Apply colour gradient from dark to light top-to-bottom to reinforce the narrowing narrative

Select range → Insert → Charts → Funnel (available in Excel 2019+)

Apply colour gradient from dark to light top-to-bottom to reinforce the narrowing narrative

Select range → Insert → Charts → Funnel (available in Excel 2019+)

Format: remove legend, remove axis, increase gap width to 15–20%

Customise via Sparkline Design tab: set high/low point colours, axis scale

For REPT bars: In a new column enter =REPT("|",[TOTALVALUE]) and set that column's font to Playbill

Adjust the divisor to control the maximum bar length – e.g. =REPT("|",[TOTALVALUE]/5); this example uses a divisor of 5

Apply conditional formatting to colour-code bars by value band (e.g. green above target, red below)

For Sparklines: Select a blank cell beside your data row → Insert → Sparklines → Line (or Column/Win-Loss) → select data range → confirm

For REPT bars: In a new column enter =REPT("|",[TOTALVALUE]) and set that column's font to Playbill

Adjust the divisor to control the maximum bar length – e.g. =REPT("|",[TOTALVALUE]/5); this example uses a divisor of 5

Apply conditional formatting to colour-code bars by value band (e.g. green above target, red below)

For Sparklines: Select a blank cell beside your data row → Insert → Sparklines → Line (or Column/Win-Loss) → select data range → confirm

Customise via Sparkline Design tab: set high/low point colours, axis scale

Adjust the divisor to control the maximum bar length – e.g. =REPT("|",[TOTALVALUE]/5); this example uses a divisor of 5

Apply conditional formatting to colour-code bars by value band (e.g. green above target, red below)

For Sparklines: Select a blank cell beside your data row → Insert → Sparklines → Line (or Column/Win-Loss) → select data range → confirm

Customise via Sparkline Design tab: set high/low point colours, axis scale

For REPT bars: In a new column enter =REPT("|",[TOTALVALUE]) and set that column's font to Playbill

Apply conditional formatting to colour-code bars by value band (e.g. green above target, red below)

For Sparklines: Select a blank cell beside your data row → Insert → Sparklines → Line (or Column/Win-Loss) → select data range → confirm

Customise via Sparkline Design tab: set high/low point colours, axis scale

For REPT bars: In a new column enter =REPT("|",[TOTALVALUE]) and set that column's font to Playbill

Adjust the divisor to control the maximum bar length – e.g. =REPT("|",[TOTALVALUE]/5); this example uses a divisor of 5

Select range → Insert → Charts → Waterfall

Right-click the first bar → "Set as Total"; repeat for the last bar and any subtotals

Format: remove gridlines

Create a table: Column A = category names, Column B = values (+ve for increases, −ve for decreases), Column C = type (mark "Total" for first and last rows)

Right-click the first bar → "Set as Total"; repeat for the last bar and any subtotals

Format: remove gridlines

Create a table: Column A = category names, Column B = values (+ve for increases, −ve for decreases), Column C = type (mark "Total" for first and last rows)

Select range → Insert → Charts → Waterfall

Format: remove gridlines

Create a table: Column A = category names, Column B = values (+ve for increases, −ve for decreases), Column C = type (mark "Total" for first and last rows)

Select range → Insert → Charts → Waterfall

Right-click the first bar → "Set as Total"; repeat for the last bar and any subtotals

Insert stacked bar chart using Start Date and Duration as two series

Select the Start Date series → Format Data Series → No Fill, No Border (makes it invisible – this is the spacer)

Set x-axis to date axis type; set minimum to your project start date as a number value; adjust major unit to 7 (weekly) or 30 (monthly)

Reverse y-axis order (Format Axis → Categories in reverse order) so tasks read top-to-bottom; add a "today" vertical line using a scatter series with error bars

Create table: Task name, Start Date, Duration (days), Category. Enter dates as real Excel date values

Select the Start Date series → Format Data Series → No Fill, No Border (makes it invisible – this is the spacer)

Set x-axis to date axis type; set minimum to your project start date as a number value; adjust major unit to 7 (weekly) or 30 (monthly)

Reverse y-axis order (Format Axis → Categories in reverse order) so tasks read top-to-bottom; add a "today" vertical line using a scatter series with error bars

Create table: Task name, Start Date, Duration (days), Category. Enter dates as real Excel date values

Insert stacked bar chart using Start Date and Duration as two series

Set x-axis to date axis type; set minimum to your project start date as a number value; adjust major unit to 7 (weekly) or 30 (monthly)

Reverse y-axis order (Format Axis → Categories in reverse order) so tasks read top-to-bottom; add a "today" vertical line using a scatter series with error bars

Create table: Task name, Start Date, Duration (days), Category. Enter dates as real Excel date values

Insert stacked bar chart using Start Date and Duration as two series

Select the Start Date series → Format Data Series → No Fill, No Border (makes it invisible – this is the spacer)

Reverse y-axis order (Format Axis → Categories in reverse order) so tasks read top-to-bottom; add a "today" vertical line using a scatter series with error bars

Create table: Task name, Start Date, Duration (days), Category. Enter dates as real Excel date values

Insert stacked bar chart using Start Date and Duration as two series

Select the Start Date series → Format Data Series → No Fill, No Border (makes it invisible – this is the spacer)

Set x-axis to date axis type; set minimum to your project start date as a number value; adjust major unit to 7 (weekly) or 30 (monthly)

Make all cells square: set row height = column width (approximately 20×20 points)

Apply conditional formatting: "Format cells where cell value <= [percentage_cell]*100" → fill with blue (#1E40AF)

Apply a second rule for the remainder: cell value > percentage → fill with light grey (#E0E0E0)

Add a percentage label in a merged cell below the grid

In a 10×10 cell block, number each cell 1–100 left-to-right, bottom-to-top (so cell 1 is bottom-left, cell 100 is top-right). Use a formula: =(ROW($A$1)-ROW())*10 + COLUMN()-COLUMN($A$1)+1 adjusted for your grid position

Apply conditional formatting: "Format cells where cell value <= [percentage_cell]*100" → fill with blue (#1E40AF)

Apply a second rule for the remainder: cell value > percentage → fill with light grey (#E0E0E0)

Add a percentage label in a merged cell below the grid

In a 10×10 cell block, number each cell 1–100 left-to-right, bottom-to-top (so cell 1 is bottom-left, cell 100 is top-right). Use a formula: =(ROW($A$1)-ROW())*10 + COLUMN()-COLUMN($A$1)+1 adjusted for your grid position

Make all cells square: set row height = column width (approximately 20×20 points)

Apply a second rule for the remainder: cell value > percentage → fill with light grey (#E0E0E0)

Add a percentage label in a merged cell below the grid

In a 10×10 cell block, number each cell 1–100 left-to-right, bottom-to-top (so cell 1 is bottom-left, cell 100 is top-right). Use a formula: =(ROW($A$1)-ROW())*10 + COLUMN()-COLUMN($A$1)+1 adjusted for your grid position

Make all cells square: set row height = column width (approximately 20×20 points)

Apply conditional formatting: "Format cells where cell value <= [percentage_cell]*100" → fill with blue (#1E40AF)

Add a percentage label in a merged cell below the grid

In a 10×10 cell block, number each cell 1–100 left-to-right, bottom-to-top (so cell 1 is bottom-left, cell 100 is top-right). Use a formula: =(ROW($A$1)-ROW())*10 + COLUMN()-COLUMN($A$1)+1 adjusted for your grid position

Make all cells square: set row height = column width (approximately 20×20 points)

Apply conditional formatting: "Format cells where cell value <= [percentage_cell]*100" → fill with blue (#1E40AF)

Apply a second rule for the remainder: cell value > percentage → fill with light grey (#E0E0E0)

Insert a horizontal bar chart using both series

Select the left series bars → right-click → Format Data Series → Series Options → drag the Series Overlap slider to 100%

Apply a custom number format to the left series' values and labels: #,##0;#,##0 – this hides the minus sign so the negative values read as plain positive numbers

Position category labels at the centre: select the category axis → Format Axis → set Label Position to "Low" → move labels manually or use a third invisible series to float centre labels

Structure data as three columns: Category, Left Series (as negative values or use axis reversal), Right Series (positive values)

Select the left series bars → right-click → Format Data Series → Series Options → drag the Series Overlap slider to 100%

Apply a custom number format to the left series' values and labels: #,##0;#,##0 – this hides the minus sign so the negative values read as plain positive numbers

Position category labels at the centre: select the category axis → Format Axis → set Label Position to "Low" → move labels manually or use a third invisible series to float centre labels

Structure data as three columns: Category, Left Series (as negative values or use axis reversal), Right Series (positive values)

Insert a horizontal bar chart using both series

Apply a custom number format to the left series' values and labels: #,##0;#,##0 – this hides the minus sign so the negative values read as plain positive numbers

Position category labels at the centre: select the category axis → Format Axis → set Label Position to "Low" → move labels manually or use a third invisible series to float centre labels

Structure data as three columns: Category, Left Series (as negative values or use axis reversal), Right Series (positive values)

Insert a horizontal bar chart using both series

Select the left series bars → right-click → Format Data Series → Series Options → drag the Series Overlap slider to 100%

Position category labels at the centre: select the category axis → Format Axis → set Label Position to "Low" → move labels manually or use a third invisible series to float centre labels

Structure data as three columns: Category, Left Series (as negative values or use axis reversal), Right Series (positive values)

Insert a horizontal bar chart using both series

Select the left series bars → right-click → Format Data Series → Series Options → drag the Series Overlap slider to 100%

Apply a custom number format to the left series' values and labels: #,##0;#,##0 – this hides the minus sign so the negative values read as plain positive numbers

Insert → Form Controls → Checkbox; draw a checkbox near the chart

Right-click checkbox → Format Control → Cell link → select a blank cell (this cell will show TRUE/FALSE)

Build your chart using the helper table (not the raw data)

Repeat for each series; align and label checkboxes; lock the worksheet to prevent accidental edits to helper cells

In your data prep area, create a helper table: for each series, write =IF(linked_cell=TRUE, actual_value, NA()) – NA() hides the series without removing it from the chart

Right-click checkbox → Format Control → Cell link → select a blank cell (this cell will show TRUE/FALSE)

Build your chart using the helper table (not the raw data)

Repeat for each series; align and label checkboxes; lock the worksheet to prevent accidental edits to helper cells

In your data prep area, create a helper table: for each series, write =IF(linked_cell=TRUE, actual_value, NA()) – NA() hides the series without removing it from the chart

Insert → Form Controls → Checkbox; draw a checkbox near the chart

Build your chart using the helper table (not the raw data)

Repeat for each series; align and label checkboxes; lock the worksheet to prevent accidental edits to helper cells

In your data prep area, create a helper table: for each series, write =IF(linked_cell=TRUE, actual_value, NA()) – NA() hides the series without removing it from the chart

Insert → Form Controls → Checkbox; draw a checkbox near the chart

Right-click checkbox → Format Control → Cell link → select a blank cell (this cell will show TRUE/FALSE)

Repeat for each series; align and label checkboxes; lock the worksheet to prevent accidental edits to helper cells

In your data prep area, create a helper table: for each series, write =IF(linked_cell=TRUE, actual_value, NA()) – NA() hides the series without removing it from the chart

Insert → Form Controls → Checkbox; draw a checkbox near the chart

Right-click checkbox → Format Control → Cell link → select a blank cell (this cell will show TRUE/FALSE)

Build your chart using the helper table (not the raw data)

Insert a doughnut chart; format zone segments with red, amber and green fills; format the bottom half segment with no fill and no border

Rotate the doughnut 270° so the flat edge sits at the bottom (Format Data Series → Angle of first slice = 270)

Add a second data series (the needle): three values – needle position, needle width (1–3), and the remaining arc value; change this series type to Pie; format the needle slice with a dark fill, the others with no fill

Overlay both charts on the same plot area; lock the chart group; add a linked text box showing the numeric value beneath the dial centre

Build a data table with four rows: the three zone sizes (e.g. 33, 33, 34 for equal thirds) plus a "blank" row to create the bottom half of the doughnut arc

Rotate the doughnut 270° so the flat edge sits at the bottom (Format Data Series → Angle of first slice = 270)

Add a second data series (the needle): three values – needle position, needle width (1–3), and the remaining arc value; change this series type to Pie; format the needle slice with a dark fill, the others with no fill

Overlay both charts on the same plot area; lock the chart group; add a linked text box showing the numeric value beneath the dial centre

Build a data table with four rows: the three zone sizes (e.g. 33, 33, 34 for equal thirds) plus a "blank" row to create the bottom half of the doughnut arc

Insert a doughnut chart; format zone segments with red, amber and green fills; format the bottom half segment with no fill and no border

Add a second data series (the needle): three values – needle position, needle width (1–3), and the remaining arc value; change this series type to Pie; format the needle slice with a dark fill, the others with no fill

Overlay both charts on the same plot area; lock the chart group; add a linked text box showing the numeric value beneath the dial centre

Build a data table with four rows: the three zone sizes (e.g. 33, 33, 34 for equal thirds) plus a "blank" row to create the bottom half of the doughnut arc

Insert a doughnut chart; format zone segments with red, amber and green fills; format the bottom half segment with no fill and no border

Rotate the doughnut 270° so the flat edge sits at the bottom (Format Data Series → Angle of first slice = 270)

Overlay both charts on the same plot area; lock the chart group; add a linked text box showing the numeric value beneath the dial centre

Build a data table with four rows: the three zone sizes (e.g. 33, 33, 34 for equal thirds) plus a "blank" row to create the bottom half of the doughnut arc

Insert a doughnut chart; format zone segments with red, amber and green fills; format the bottom half segment with no fill and no border

Rotate the doughnut 270° so the flat edge sits at the bottom (Format Data Series → Angle of first slice = 270)

Add a second data series (the needle): three values – needle position, needle width (1–3), and the remaining arc value; change this series type to Pie; format the needle slice with a dark fill, the others with no fill

Prepare your images: PNG or SVG files, ideally square-format, transparent background, consistent dimensions

Copy the image to clipboard (Ctrl+C on the image file or image in a cell); click once to select the chart series, then click again to select a single bar, and paste with Ctrl+V – the image fills the bar

Right-click the filled bar → Format Data Series → Fill → "Stack and Scale with" → set units-per-picture to a meaningful value (e.g. 1 icon = 10,000 units); repeat for each bar if different images are needed per category

Build a standard column or bar chart using your data

Copy the image to clipboard (Ctrl+C on the image file or image in a cell); click once to select the chart series, then click again to select a single bar, and paste with Ctrl+V – the image fills the bar

Right-click the filled bar → Format Data Series → Fill → "Stack and Scale with" → set units-per-picture to a meaningful value (e.g. 1 icon = 10,000 units); repeat for each bar if different images are needed per category

Build a standard column or bar chart using your data

Prepare your images: PNG or SVG files, ideally square-format, transparent background, consistent dimensions

Right-click the filled bar → Format Data Series → Fill → "Stack and Scale with" → set units-per-picture to a meaningful value (e.g. 1 icon = 10,000 units); repeat for each bar if different images are needed per category

Build a standard column or bar chart using your data

Prepare your images: PNG or SVG files, ideally square-format, transparent background, consistent dimensions

Copy the image to clipboard (Ctrl+C on the image file or image in a cell); click once to select the chart series, then click again to select a single bar, and paste with Ctrl+V – the image fills the bar

Add a helper column for cumulative %: =SUM($B$2:B2)/SUM($B$2:$B$[last row]) – format as percentage

Excel 2016+: Select both value and cumulative % columns → Insert → Charts → Histogram → Pareto – done

Format: set secondary y-axis max to 1 (100%); add a constant series at 0.8 as a dashed horizontal reference line; label the 80% line; set bar colours descending dark-to-light green; format line with red

Sort your data descending by value (largest category first)

Excel 2016+: Select both value and cumulative % columns → Insert → Charts → Histogram → Pareto – done

Format: set secondary y-axis max to 1 (100%); add a constant series at 0.8 as a dashed horizontal reference line; label the 80% line; set bar colours descending dark-to-light green; format line with red

Sort your data descending by value (largest category first)

Add a helper column for cumulative %: =SUM($B$2:B2)/SUM($B$2:$B$[last row]) – format as percentage

Format: set secondary y-axis max to 1 (100%); add a constant series at 0.8 as a dashed horizontal reference line; label the 80% line; set bar colours descending dark-to-light green; format line with red

Sort your data descending by value (largest category first)

Add a helper column for cumulative %: =SUM($B$2:B2)/SUM($B$2:$B$[last row]) – format as percentage

Excel 2016+: Select both value and cumulative % columns → Insert → Charts → Histogram → Pareto – done