A RACI chart is a simple table that shows who does what in a project. RACI stands for Responsible, Accountable, Consulted and Informed. Each task is a row, each person or team is a column, and each cell holds one of the four letters or stays empty. The chart removes confusion, because everybody can see who does the work, who makes the final decision, who gives input and who only needs to know. Excel is ideal for building one, since drop-downs keep the letters consistent and formulas can check the rules automatically. This guide shows the layout, the drop-downs, the color rules and the checks, with a small project example you can follow from start to finish.
Updated November 2026
In this guide
- What the four letters mean
- Example project
- Step 1: set up the layout
- Step 2: add the drop-downs
- Step 3: fill in the chart
- Step 4: color the letters
- Step 5: check for one accountable person
- Step 6: highlight problems
- Step 7: count the workload per person
- Add dates and status
- Tips for using the chart
- Common mistakes
- Practice problems
- Quick recap
What the four letters mean
Responsible (R) means the person who does the work. There can be more than one. Accountable (A) means the person who owns the result and signs it off. There should be exactly one per task. Consulted (C) means people who give advice before a decision, and the communication goes both ways. Informed (I) means people who are told about the result, and the communication goes one way. A person can be both A and R on a small task, and in that case many teams write A/R. Keep the meaning simple and agree it with the team before you start.
Example project
Take a website launch with five tasks and four people. The tasks are Write content, Design pages, Build site, Test site and Approve launch. The people are Project manager, Writer, Designer and Developer. We will fill in the chart so that each task has one A and at least one R. For example, the Writer is R and the Project manager is A for Write content. The Developer is R for Build site and Test site. The Project manager is A for every task except Design pages, where the Designer might be both.
Step 1: set up the layout
Type the project name in A1. In A3 type Task, and in B3 to E3 type the four roles. Type the five tasks in A4:A8. Add the headers Accountable count and Responsible count in F3 and G3 for the checks. Widen the columns, center the letters and add a thin border. Freeze the header row, as shown in our freeze panes guide, if the chart will have many tasks. Put the key to the letters under the chart, so that readers do not need to look it up.
Step 2: add the drop-downs
Select B4:E8, go to Data, Data Validation, choose List and type R,A,C,I in the source. Each cell now has a drop-down, and typing anything else is rejected. You may also allow A/R for combined roles by typing R,A,C,I,A/R. Our drop-down list guide explains how to set the error message, so users get a clear warning when they type an invalid letter.
Step 3: fill in the chart
For Write content, set the Writer to R and the Project manager to A, and the Designer to I. For Design pages, set the Designer to A/R, the Writer to C and the Project manager to I. For Build site, set the Developer to R, the Project manager to A and the Designer to C. For Test site, set the Developer to R, the Designer to C and the Project manager to A. For Approve launch, set the Project manager to A/R, since the manager both decides and signs off, and the Developer and the Designer to I. Every task now has one accountable person and at least one person doing the work. Review each row with the team.
Step 4: color the letters
Select B4:E8 and add conditional formatting with the rule Equal To, and a different fill color for each letter: for example green for R, red for A, yellow for C and blue for I. The colors make patterns easy to see. A column full of R shows an overloaded person, and a column full of I shows someone who may not need to be on the project. Use colors that print clearly in black and white, and keep the letters visible, so the chart still works for color-blind readers.
Step 5: check for one accountable person
Add a check in F4 with =COUNTIF(B4:E4,"A")+COUNTIF(B4:E4,"A/R"). The result should be 1 in every row. Add a second formula in G4, =COUNTIF(B4:E4,"R")+COUNTIF(B4:E4,"A/R"), which counts the people doing the work, and it should be at least 1. Fill both down. Then add a status in H4 with =IF(AND(F4=1,G4>=1),"OK","Check"). A row with no A, two A’s or no R shows Check. Our IF statements guide explains the logic.
Step 6: highlight problems
Apply conditional formatting to the status column so that Check turns red and OK turns green. You can also add a summary cell at the top with =COUNTIF(H4:H8,"Check"), which shows how many rows need attention. The number should be 0 before you share the chart. This simple control stops the most common RACI problem, which is tasks with no owner or with several owners who each assume that someone else decides.
Step 7: count the workload per person
Under each role column, add a count of the tasks where the person is R, with =COUNTIF(B4:B8,"R")+COUNTIF(B4:B8,"A/R"). In our example, the Project manager has 1, the Writer has 1, the Designer has 1 and the Developer has 2. The total is 5, because the Developer works on two tasks. Compare it with the number of A’s, which is 4 for the Project manager. These counts show who is carrying the most work. If one person has far more R’s than the others, move some tasks or add help. Our project tracker guide shows how to follow the tasks over time.
Add dates and status
A RACI chart answers who, but not when. You can add the columns Due date and Status next to the letters, or link the chart to your project tracker. Use the same task names in both files, so that a lookup works. With XLOOKUP, you can pull the due date from the tracker into the chart. Keep the chart short, ideally one page, and split big projects into phases, each with its own chart. Review the chart at the start of each phase, since roles often change.
Tips for using the chart
Agree the chart in a meeting, not by email, so that each person understands the roles. Keep the number of C’s small, because too many consulted people slow down decisions. Keep the number of I’s reasonable too, so people do not drown in updates. Write the decision rule next to the chart, such as the A decides after hearing the C’s. Save the file in a shared place, and add the date of the last change. If a role has no name yet, write the job title and replace it later.
Common mistakes
The most common mistake is to have two A’s on one task, which leads to conflict. Another is to have no A, so nobody makes the final decision. A third is to give every person a letter on every task, which makes the chart useless. A fourth is to mix up C and I, so that people who should give input only receive news. A fifth is to build the chart once and never update it. A sixth is to use names of teams where a single person should be accountable.
Practice problems
Try these. Problem 1: a task with the letters A, R, C and I in four cells has one accountable person, so the check column shows 1. Problem 2: a row with A, A, R and I has two accountable people, so the check column shows 2 and the status shows Check. Problem 3: a row with A, C, C and I has no responsible person, so the status shows Check. Problem 4: build the chart in this guide and confirm that the Developer has 2 R’s. Problem 5: change one A to a second R and watch the status change.
Quick recap
List the tasks in rows and the roles in columns. Use a drop-down with R, A, C and I, and color each letter. Check that each task has exactly one A and at least one R with COUNTIF and IF formulas. Count the R’s for each person to see the workload. Agree the chart with the team, keep it short and update it at the start of each phase. A clear RACI chart saves time, prevents arguments and keeps the project moving.
Frequently asked questions
What does RACI stand for?
Responsible, Accountable, Consulted and Informed.
How many accountable people can a task have?
Exactly one.
How do I make a RACI chart in Excel?
List tasks and roles in a grid, add a drop-down with R, A, C and I, and check each row with COUNTIF.
What is the difference between responsible and accountable?
Responsible people do the work, and the accountable person owns and signs off the result.
Can one person be both R and A?
Yes, on small tasks, and many teams write A/R.


