The column chart in Excel
Employer
[no-member:pro]Anna[/no-member:pro]
Project parameters
Type of cooperationOne-time project
SectionDesign and multimedia
Prepaymentprepayment is possible
Payment methodsBank transfer
Acceptance of requestsfrom Oct 13, 2020 until Oct 16, 2020
Project description
A specialist in creating column charts in Excel is required. You need to create a diagram in Excel. There is a table of training data. You need to make two column diagrams of the distance traveled for each name.
The table shows the names of the dogs vertically. There's a line at the top with the distance. The sign “+” in the table means that the distance is covered. The letter "l" means that the dog was the leader. We need to make two column charts. The first is the name of the dog and the distance traveled. I mean. We set a condition - if the cell is "+" or "l" then we sum up the distance traveled. The second diagram is the dog’s name and distance traveled in the leader position. I mean. Only those distances are summed up where the "l" sign stands in the cell. Table in the enclosure.
The table shows the names of the dogs vertically. There's a line at the top with the distance. The sign “+” in the table means that the distance is covered. The letter "l" means that the dog was the leader. We need to make two column charts. The first is the name of the dog and the distance traveled. I mean. We set a condition - if the cell is "+" or "l" then we sum up the distance traveled. The second diagram is the dog’s name and distance traveled in the leader position. I mean. Only those distances are summed up where the "l" sign stands in the cell. Table in the enclosure.
