Why is my data not showing up on Excel graph?
By default, Excel displays only visible data in a chart. Consequently, if you hide worksheet data, Excel won’t display that data in a chart. In the Active Chart section, clear the Plot Visible Cells Only Option. Click OK.
How do I edit a chart in Excel 2010?
Click the chart. On the Charts tab, under Data, click the arrow next to Edit, and then click Edit Data in Excel. Excel opens and displays the data table for the chart.
How do I graph data in Excel 2010?
Vertical Axis
- Select the cells you want to chart, including the column titles and row labels.
- Click the Insert tab.
- In the Charts group, select the desired chart category (Column, for example).
- Select the desired chart type from the drop-down menu (Clustered Column, for example).
- The chart will appear in the worksheet.
How do I find hidden data in Excel?
To unhide all of the cells in a worksheet:
- Click the Select All button, in the upper-left corner of the worksheet or press Ctrl + A.
- Click the Home tab > Format (in the Cells group) > Hide & Unhide > Unhide Rows or Unhide Columns.
- All cells are now visible.
How do you show all data in Excel?
View All Data in Worksheet: MS Excel
- Select the current region.
- Press Ctrl + *.
- Choose View | Zoom.
- Select Fit selection.
- Click OK.
Why does my chart keep saying no data?
If your form has blank rows, it may be because these rows used to have data in them but they were deleted. To truly delete rows, highlight the rows by clicking on the “2” and dragging to “5”.
How do I show a chart in Excel?
Click INSERT > Recommended Charts. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look. If you don’t see a chart you like, click All Charts to see all the available chart types.
How do I find data tables in Excel?
If you go to Formulas tab of the Ribbon > Name Manager you will see Table names listed amongst other defined names. They show a different icon next to them, but to make things even clearer you can use the Filter button at the top right to show tables only.