![]() ![]() In Excel 2013 and Excel 2016, you can click the Recommended Charts button to view a gallery of pre-configured graphs that best match the selected data. To add the graph on the current sheet, go to the Insert tab > Charts group, and click on a chart type you would like to create. To select all used cells on the worksheet, place the cursor in the first cell of the used range (press Ctrl+Home to get to A1), and then press Ctrl + Shift + End to extend the selection to the last used cell (the lower-right corner of the range). Please note, you can plot non-adjacent cells or ranges in a chart only if the selection forms a rectangle.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |