chart x-axis values appear as a series

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?
 
J

Jon Peltier

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
 

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
Secondary axis not aligning to X axis 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Placing an arrow on the series line in a line chart 5
Pivot Chart Time Series work around? 1
Source Data - Values - Dynamic Range possible? 2

Top