22  To convert data into a bar graph:  Conditional formatting in Excel can be used to convert cells with numeric data into a bar graph. Two bar  graph options are gradient and solid filled graphs. 3. Hover over  Data Bars . 1. Highlight your entire data range. 2. Select  Conditional Formatting . Data Bars 