Excel labels on X Axis

Questions about running any kind of software, such as how-to's and fixes for MS Office, Adobe Acrobat, etc., or how to do stuff in Windows.
Post Reply
stry
Posts: 3
Joined: Sun Jun 10, 2007 4:22 pm

Excel labels on X Axis

Post by stry » Sun Jun 10, 2007 4:29 pm

Can you help me? I am trying to create a chart in Excel with two data sets, and the corresponding years across the X-axis. However, I cannot get it to include the years, just a set of numbers 0-6 (the number of data points). I tried adding the years as a new data set, but that messes up the chart. What am I doing wrong?

User avatar
hal_nesbitt
Site Admin
Posts: 32
Joined: Thu Jul 24, 2003 5:53 pm
Location: Alexandria, VA
Contact:

Post by hal_nesbitt » Sun Jun 10, 2007 4:57 pm

Hi stry. The trick is in the chart wizard. Select the two sets of data, click the chart wizard, choose line graph (not scatterplot), then click the 'series' tab and at the bottom define a range for the “Category (x) axis labels” option by highlighting your cells with the years in them. Follow the rest of the prompts through the wizard as normal to generate the chart. Let me know if you have any problems.
"Maturity is stupid." - Benjamin Franklin

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests