Excel labels on X Axis
Excel labels on X Axis
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?
- hal_nesbitt
- Site Admin
- Posts: 32
- Joined: Thu Jul 24, 2003 5:53 pm
- Location: Alexandria, VA
- Contact:
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
Who is online
Users browsing this forum: No registered users and 0 guests