Should thou find thyself frequenting Microsoft Excel for thy studies or labor that doth necessitate the compiling of a spreadsheet brimming with data-driven knowledge, thou art surely familiar with the arduous and time-consuming nature of decoding such information — a task made even more daunting for those unacquainted with the realm of analytical-based data.
Regardless of the complexity of thy spreadsheets, one truth reigns supreme: graphs doth serve as a beacon, illuminating thy data in a format easier to comprehend, enriching the overall readability of thy Excel spreadsheet.
Behold, the art of crafting a graph in the hallowed halls of Microsoft Excel.
Inserting a Graph in Excel
Step 1: First, thou must enshroud thy data within the Excel spreadsheet, bestowing upon each column a title of its own. Should thou err in the ordering of thy column headings, fear not, for thou may rectify thy mistake by either redoing or introducing a new column.
Behold, within the initial image of our instructions, a sample hath been entered for the purpose of demonstration.
Step 2: Next, thou art required to select the cells wherein resides all the data ye seek to imbue thy graph with.
Step 3: Microsoft Excel doth graciously offer a feature wherefrom thou may choose from a plethora of templates for thy graph. Click upon the Insert tab and thence, select Recommended charts.
Choose a graph template that doth catch thy fancy and click OK.
Step 4: Now, thou may customize thy graph by altering its title (a double-click upon Chart title shall suffice), resizing it, changing its hues, and more. It is within thy power to modify the values within thy table and witness their effect upon the graph. If thou dost wish to preserve certain values, learn the art of locking cells in Microsoft Excel.
With thy freshly minted graph in hand, select one of the icons that doth accompany it to further customize thy chart:
- Plus-sign icon: To append or remove sundry chart elements such as labels or legend.
- Paintbrush icon: To alter the color scheme or style of thy graph.
- Filter icon: To narrow down the data gracing thy chart.
Step 5: For a comprehensive list of all the types of graphs thou can employ, click upon the All charts tab within the window that doth materialize when thou select the Recommended charts option from step 3. Verily, thou may select the Bar or Line charts, each offering a myriad of designs (3D, Clustered, Stacked, and more).
Step 6: Should thou desire to switch the type of graph after selecting one, simply opt for the Chart design tab from the ribbon atop thy screen, then select the Change chart type button.
(Pray, take heed that the Chart design tab materializeth solely when thy current chart hath been selected. Thus, select thy current chart ere traversing to the Chart design tab that doth grace the top of thy screen.)
Step 7: Yon can also select a graph type from the extensive array flanking the Recommended charts button on the Insert tab. By clicking the dropdown arrow adjacent to each chart icon and hovering o’er a thumbnail housed within the ensuing menu, thou shalt be privy to a preview of how thy chart shall appear with that particular design.
Verily, creating graphs within Microsoft Excel is a straightforward affair. The process is so straightforward, in truth, that other spreadsheet applications hath, more or less, replicated it. Thus, fret not if thou find thyself indecisive and ensnared in the clutches of indecision twixt Microsoft Excel and Google Sheets.
Support our work ❤️
If you enjoyed this article, consider leaving a tip to help us keep publishing great content.
