HINT: Use Select Data
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn0Vyi3-3a49yY18w59mNwTTFK0Kz8XCTPV14U98XmmZ9PnWv_7Jw5Kt5EE-kK2vTN0iTa6HLQsQ72SFrgKYMipLE40ZiH5ZFv8B87_WjMNB1s4wYLiYZ553fYCyC_yExYWaTty8gj6HM/s400/hor+ax+01.png)
Step 01:
Type your data chart and type also your new axis label.
I will change horizontal axis label (1,2,3,....13) to 1993,1994,1995,...,2005
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwM-hZcQU4UkdCvUF2syMLwi65JsIM4W1ZnGngIyaDDl1X9KzM32cW3tytZgQru_QylC4J1JxKAXJNTNBtt_gJIDKk8jAaW-hOr1RNWNCeouKAhXo8PUwURoKtQX6u46_9tQmTpN9uKJg/s400/hor+ax+02.png)
Step 02:
Now, click on label number exactly (example click horizontal axis label 7). Then you will see all horizontal axis label selected.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0fxgawPQZbRMuNfda1uhbrcKxf7oTNWTJdN0E-O6ThVJkqnis5N_4Pkn4cHE9-MtBlmEqyNrZFougUOYyFtyiTE7r0XwaX1oJfP5GCeIUtQDIfWpwrXdXwrEGy98Qn-Z4eeDwSBrXnz4/s400/hor+ax+03.png)
Step 03:
After that, right-click it and then you will see the menu. Click Select Data...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheGw4B197OitXiljvwR3eSK8MlrD6XY18Kj9e18V3ALtsgpRZTrqgYWCTQh19nSWA1OC__RPCJ1UoiYPGN4U42d-uh372Co61ds_Dved6Ov-Fs9QSLCQxaBuuBSajH9lQWf7XVKWy-wXY/s400/hor+ax+04.png)
Step 04:
The Select Data Source window will appear. Select right Edit button (see picture):
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT2igyvgSJXvu3uSkkp2RokGZGxkfZJn6tP8LUmExzlWi4zqNaYqRtGJA3x6f9uFPiG8pZE8sspo0jD983x5vGzzkhHtGnbsL4rG8nhrlp7DWbOwFUlAEpId6OW2rcgkE5cG2UCH_1b0I/s400/hor+ax+05.png)
Step 05:
Axis Labels window appear. Click the range button (see picture):
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKsNbuMTa4W8cJN9bn55kid94bIa5d8n7il1QdUbUVIH7ue22FCbbNeIJhUx7QCqQsckm4Qel-Zosq8bBX8Kxzg-g6BOCAuBI7B8A3jLcCrGBXzi9byO18Eqqe6RQ9RRQEdDSQrA9dyeQ/s400/hor+ax+06.png)
Step 06:
Select your new axis label. In this case, I select Year column.
Selected cells will marked like ants march. If you done, click OK button.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbzz8cN5rlL13K9UGPF15Fhxhdx2HwH-OubBTnEGunrUxL_zQNg-o2y5ShehYj3eeI0kfjxsH7y1qNh2RqIIdAtqJqKAS6kw-lN0IYHGmF4IOCGbPeX5uxC_1toA6fWg_N74bvnC58M68/s400/hor+ax+07.png)
Step 07:
The Select Data Source window will appear again. See that Horizontal (Category) Axis Labels now 1993, 1994, ......, 2005. Click OK button to finish it.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsy45lyVMQK_Yk6RPr73WSbZE75MxGSGwnFLLhd7inDMNEO8Dy2aquoocZyNJONcS-uh4yaghyphenhyphen7sgnIIPnmpVgxbXxvGLLX_quy0q1aDbxqRHGPP5e9TR2Ey7zwh29axiunLEJnyXrJIs/s400/hor+ax+08.png)
Step 08:
Now, you will see your horizontal axis label will change to year.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWzDtMHhkA_Cv7I5L2X8OQaPo7VeNkNtj0Evh_WbXcxHJcH8rbgVXcsMxwOFalUsu93R1giIQ_kxJ81782Eg-n_UV3FFaC3YSVmdoXtq5kFr9YDmjiNi-cjD7XQn9-7s5HFlu31Mo1eeE/s400/hor+ax+09.png)
No comments:
Post a Comment