To make a chart right in the worksheet cells, use Excel Data Bars, built with conditional formatting. See how to add a standard set of Data Bars (Excel 2007 and later), and adjust their settings to make the bars look better.

要在工作表单元格中正确制作图表，请使用条件格式构建的Excel数据栏。 了解如何添加一组标准的数据栏(Excel 2007及更高版本)，并调整其设置以使数据栏看起来更好。

And remember to mark your calendars – next Tuesday, October 17th, is Spreadsheet Day – alert your family and friends!

记住要记下您的日历-10月17日星期二是电子表格日 -提醒您的家人和朋友！

First, to add a standard set of Data Bars , follow these steps:

首先，要添加一组标准的数据栏，请按照下列步骤操作：

NOTE: You can change the Fill Style (gradient or solid) later, or choose a different colour for the Data Bars.

注意 ：您可以稍后更改填充样式(渐变或纯色)，或为数据栏选择其他颜色。

The selected cells will show Excel Data Bars, along with the original numbers. In the screen shot below, the Green Gradient data bar option was selected

选定的单元格将显示Excel数据栏以及原始数字。 在下面的屏幕快照中，选择了“绿色渐变”数据栏选项