Home / Software / Graphs

Graphs

Excel has a good number of graphs that can be used with Excel spreadsheets. Such graphs can be included on the spreadsheet or separately. The graphs really chart the spreadsheet cells, with various options available to modify and enhance any chart.

To begin a graph simply select the range of relevant cells you wish to include in the graph. Then, select the graph option from the toolbar, on the right, to start the chart wizard.

When the chart wizard begins, the first step is selecting a chart type. This is most important, and Excel will have a variety such as: bar, column, line, pie, scatter, cone and stock graphs. Overall, the graph type you select should be appropriate relating to cells selected. For example, a pie chart displays contribution of each value to a total. Bar or column graphs are better for comparing values.

Just to note that Excel actually has some pre-formatted customised graphs available for selection with the custom tab. You can select one of these, for a graph short cut.

Following the chart wizard, you can then add to the graph. On step three, do add a chart title, alongside a title for the x and y-axis. Under data labels, you can also include values on the chart as well. Or alternatively, a data table which is a good addition.

For the final step you can either include the graph on a new sheet or in the same worksheet Personally, I feel that it is best to include graphs in a separate sheet, where it will be larger. If you include the graph within a spreadsheet, then you will likely need to drag and move the graph to a good spot on the sheet.

Once the chart wizard is finished, and the graph placed on the spreadsheet, then you can still modify the graph. To do so, right-click within the graph area. From here, you can select the options to modify.

To note that, with 3d view, you can modify the elevation and rotation of 3d graphs. You can also further format the chart with formatting options.

You can also format any small part of the graph, such a single data value or legend entry. To do so, simply click once and then twice on the part of the graph you wish to format. From here, you right-click and then select format for options.

So overall, Excel has a variety of graph & chart options. Using the chart wizard or otherwise, you can have exciting graphs for your spreadsheet.

About User Lin