Chart Date Text For Free

The issue is very simple. In the "won't graph" table, the numbers are stored as text. To fix this, just retype the numbers, click on the green prompt to the side of the box, or paste it to and from another application (excel should autodetect it as a number). Thanks, of course you are correct.

Select Range to Create a Graph from Workbook Data Your cell range will now be highlighted in gray. Once the text is highlighted you can select a graph (which Excel refers to as chart). Click the Insert tab and click Recommended Charts on the toolbar. Then click the type of graph you wish to use.

Once the text is highlighted you can select a graph (which Excel refers to as chart). Click the Insert tab and click Recommended Charts on the toolbar. Then click the type of graph you wish to use.

ExcelIn your spreadsheet, select the data to use for your pie chart.Click Insert > Insert Pie or Doughnut Chart, and then pick the chart you want.Click the chart and then click the icons next to the chart to add finishing touches:

Click the "Insert" tab, click "Bar" from the Charts group, and then select any of the chart types from the drop-down menu's first column. Excel automatically creates a chart with your word variables along the left and data plotted within the chart itself.

Add a chart to your document in WordClick Insert > Chart.Click the chart type and then double-click the chart you want.In the spreadsheet that appears, replace the default data with your own information.When you've finished, close the spreadsheet.If you want, use the Layout Options button.

Add a text box to a chartClick the chart to which you want to add a text box.In Office 2013 and newer versions: On the Format tab, in the Insert Shapes group, click the Text Box icon .In the chart, click where you want to start a corner of the text box, and then drag until the text box is the size that you want.More items...