Chart Based on Conditional Formatting

 

 

     

  • Prepare chart based on conditional formatting
  • Total marks mentioned in B column
  • Add C,D,E,F,G Columns as per our requiement of Grading
  • Select all the data from A1 to G8 and create chart