Creating and printing graphs
Let's start with the usual workcase study2 / 4
XOctober_sales report.xlsm - Excel
A1moon
| A | B | C | D | |
|---|---|---|---|---|
| 1 | moon | Sales (yen) | ||
| 2 | July | 120,000 | ||
| 3 | August | 180,000 | ||
| 4 | Sep | 150,000 | ||
| 5 | ||||
| 6 | ||||
| 7 | ||||
| 8 |
Monthly salesReady
Ready
KeyCat
Next are the meeting materials. Let's create the usual graph by entering this month's sales.
This is an operation image using fictitious data. Saving and printing are reproductions of what is on the screen. It does not manipulate actual files or printers. Processing speed is a matter of performance.
This is an exercise that reproduces the Windows version of Excel. The keys on the ribbon differ depending on the display language, so you can also use the buttons on the screen. On Mac, open VBE with Option+F11. Depending on your keyboard settings, you may also need the Fn key. The VBA syntax and the function name passed to .Formula remain in English.