CODEWITHSUNDEEP
excelcharts
josepdecid
josepdecid

Reputation: 1847

How to do a conditional chart in excel?

I have two columns 'age' and 'assistance' and I'd like to have a line chart that given the ages in the X-axis, it shows how many of them have assisted (assistance == true) in the Y-axis.

e.g -> There are three 29yo assistants

Upvotes: 0

Views: 431

Answers (1)

Chris
Chris

Reputation: 106

See below picture, I added a helper column "C", and then created a pivot table/chart from the table data.

The helper formula in C7 is =IF(B7,1,0)

This converts the TRUE to a number 1, allowing you to sum the age in a pivot table / chart.

Image of my setup > 1

Upvotes: 1

Related Questions