Karraj.Ĭharting, how to make x axis display the desired dates only, I have dates in x axis and values in y axis. I want to display the given dates and the associated data. My dates are unevenly distributed, diff between successive dates are 5 to 7 days. I have dates in x axis and values in y axis. Under Units, next to Base, select Days, Months, or Years. How to make x axis display the desired dates onlyĭisplay or change dates on a category axis, is selected. If I select just 1 set of values (1 column of X values and 1 columns of Y values with a series name on top) it will plot the Y values vs the position (1-35 rather than the actual X values) and when I hover over them it will say something like: Series 'Name' Point 'X value' (Y value, position) where X value is the number I actually want on the X axis, but position ) the plot is displayed with x-axis values as 1,2,3 but not as the data specified. When I want to add a new series with similar x-axis data (0.0, 0.4, 0.9. I have an excel scatter plot with 5 different data series on single chart. When I insert a column chart, the xĮxcel scatter plot x axis displays only sequential numbers but not real data selected for x axis.
The next column is 'amount' which has dollar amount values. Excel chart x axis showing sequential numbers, not actual value
