![]() To promptly create an appropriate graph for the selected data, you can make use of the Quick Analysis Charts features.You can also choose other graph types on the left hand side of the dialog. The Insert Chart dialog window will open, and you will see a list of available column chart sub-types at the top. To do this, click the arrow next to the Column Chart icon and choose one of the chart sub-types under the 3-D Column category.įor more chart types, click the More Column Charts… link at the bottom. In this example, we are creating a 3-D Column chart. In Excel 2013 and higher, 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 |