Format your stacked bar charts
Posted: Sat Apr 19, 2025 9:03 am
Next, you'll need to reverse the order of the tasks so that your critical path starts with task number 1. Simply select all your task lists along the vertical axis of your Gantt chart, click the "Bar Chart" icon, and choose "Format Axis." You'll then see a checkbox labeled "Categories in Reverse Order." Click it.
But that's just the tip of the iceberg. I invite you to check out our ultimate guide to Gantt charts to learn more about all the benefits of Gantt charts.
How to Create an Excel Gantt Chart on Mac?
Want to create an Excel Gantt chart on a Mac computer? It turns rcs data usa out it's a little easier than creating a Gantt chart on a PC.
Follow these steps:
Create your Excel table
Write a to-do list and insert it into an Excel spreadsheet.
Turn your Excel table into a stacked bar chart
Click “Insert,” “Insert Bar Chart,” and then select “Stacked Bar Chart.”
Format your Excel bar chart
Click on your data series, go to the "Format" tab, then select "Fill" and "No Fill." To get your Gantt chart in reverse task order (so you start with the first task start dates), hold down the Ctrl key and select your vertical axis. Then click "Format Axis" and select "Categories in Reverse Order" under "Axis Position."
And that's it. But once you've got the basics down, you can add small customization touches like color-coding (if you prefer blue bars to orange bars, for example), and save your new Gantt chart as a template for future use.
But that's just the tip of the iceberg. I invite you to check out our ultimate guide to Gantt charts to learn more about all the benefits of Gantt charts.
How to Create an Excel Gantt Chart on Mac?
Want to create an Excel Gantt chart on a Mac computer? It turns rcs data usa out it's a little easier than creating a Gantt chart on a PC.
Follow these steps:
Create your Excel table
Write a to-do list and insert it into an Excel spreadsheet.
Turn your Excel table into a stacked bar chart
Click “Insert,” “Insert Bar Chart,” and then select “Stacked Bar Chart.”
Format your Excel bar chart
Click on your data series, go to the "Format" tab, then select "Fill" and "No Fill." To get your Gantt chart in reverse task order (so you start with the first task start dates), hold down the Ctrl key and select your vertical axis. Then click "Format Axis" and select "Categories in Reverse Order" under "Axis Position."
And that's it. But once you've got the basics down, you can add small customization touches like color-coding (if you prefer blue bars to orange bars, for example), and save your new Gantt chart as a template for future use.