Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In Excel 2010, chart data series don't seem to show the X axis value. When you put your cursor on a certain data point, it shows "Series(Y axis value)"/ "Point(X axis value)"/ and "Value". The X axis value is text-type date series, eg 20010101, 20010102, 20010103.

Instead of showing this X axis value like "20010101", "20010102", it shows only the sequence of the X axis data- Point "1", Point "2", Point "3", and so on. When I check the source data, it shows correct X axis value in 'Horizontal Axis Labels'.

Charts in Excel 2003 didn't have this kind of issue. How can I solve this problem to show the proper X axis value?

share|improve this question
    
Is it a scatter chart? –  Tim Williams Jun 18 '13 at 0:59
    
No it's column chart –  E Park Jun 18 '13 at 1:15
    
SO is for programming questions. A question like this does not belong here, but on SuperUser.com instead. –  teylyn Jun 18 '13 at 2:35
    
Please add an example (e.g. screenshot). –  dav Jun 20 '13 at 17:12
add comment

migrated from stackoverflow.com Jun 19 '13 at 5:20

This question came from our site for professional and enthusiast programmers.

1 Answer

What range is specified for the X axis in the data source dialog?

If the data looks like numbers, and there is a label in the top left cell of the source data table, Excel will treat the first column like a data series, and not as X axis labels. Make sure that the top left cell (above the labels) is empty before creating the chart.

To fix an existing chart, open the Select Data dialog and adjust the source of the X axis labels.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.