Previous Lecture Complete and continue  

  Insert Miniature Bar Charts Called Data Bars*

Data Bars are miniature within-cell bar charts. They help you explore a dataset and get ideas for further analyses. I also use them in dashboards.

  • Highlight or select the cells that you want to visualize.
  • Go to the Home tab.
  • Go to the Conditional Formatting icon.
  • Scroll down to the Data Bars section and select a Solid Fill color. Avoid the Gradient Fill, which look super cool at first but are actually super difficult to read.

Next, we'll edit these Data Bars. We'll adjust the scale, the label placement, the color, and the background shading.