chart x-axis values appear as a series

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The x-axis values do not appear on the x-axis but appear as another series on
the chart. How do I specify the x-axis values for a chart?
 
Existing chart:

Chart menu > Source Data > Series tab.

For a new chart, fix the data first. Put the X values in the first column
and Y values in the columns to the right. Put a label (series name) in the
row above the first row of data for each set of Y values, but keep the cell
atop the X values blank. Select the entire range, including X values, series
names, and blank cell, then start the chart wizard. The blank cell helps
Excel interpret the data range.

- Jon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
One extra x axis item that wont go away - can anyone help? 3
How do I adjust marker spacing in Excel scatter plot? 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Pivot Chart Time Series work around? 1
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
Secondary axis not aligning to X axis 1
Make Y-axis values correspond to x- axis value 1

Back
Top