Mobile menu

Excel Charts: Making the X axis display years
Thread poster: Fuad Yahya
Fuad Yahya  Identity Verified
Arabic
+ ...
May 3, 2007

How do I make the X axis in an Excel chart (simple columns) display a series of years (e.g., 2001, 2002, 2003, etc.)? I am using Excel 2003. Currently, the X axis shows a series of numbers starting from 1. I cannot make these numbers start from any other number. I would like to be able to make them start from, say, 1968 or 2005 or something like that. Thank you very much.

Direct link Reply with quote
 

Henrik Pipoyan  Identity Verified
Local time: 14:16
Member (2004)
English to Armenian
Hi Fuad May 3, 2007

You need to write the years on the first row. If you have already done so, do the following: When selecting the data for the chart, do not select this row, where the years are. Go to Insert > Chart. The chart wizard will open, and, you have to pass several steps. On the first step you accept the chart type, then, on the second step you have to indicate the chart source data. When you reach this step, you'll see two tabs "Data Range" and "Series". Open the "Series" tab and below the dialog box you'll see "Category (X) axis labels:". Put you mouse in this field, and then select the row of the years by the mouse. The years will be added as labels for the X axis.

I hope this helps.

Henry


Direct link Reply with quote
 
Fuad Yahya  Identity Verified
Arabic
+ ...
TOPIC STARTER
Perfect May 3, 2007

Thank you very much.

Direct link Reply with quote
 

Henrik Pipoyan  Identity Verified
Local time: 14:16
Member (2004)
English to Armenian
My pleasure May 3, 2007



Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Excel Charts: Making the X axis display years

Advanced search






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs