Articles → EXCEL → Create A Bar Chart In Excel Cells Using Conditional Formatting In Office 365

Create A Bar Chart In Excel Cells Using Conditional Formatting In Office 365






Sample Data




Picture showing the sample excel file used for creating the bar chart

Click to Enlarge


Add Bar Chart






  1. Select column D
  2. Picture showing selecting the last column of the table for creating the bar chart

    Click to Enlarge

  3. Click on Conditional Formatting – Data Bars – More Rules…
  4. Picture showing selecting the more rules section of the conditional formatting

    Click to Enlarge

  5. Following window will appear
  6. Picture showing the rule window of the conditional formatting

    Click to Enlarge



    Picture showing the bar and data in the last column of the excel

    Click to Enlarge



    Picture showing the bar in the last column of the excel

    Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Friday, October 26, 2018

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250