map one column to x axis second to y axis in excel chart for ms excel 2010 i struggled with same issue i e instead of x y chart it was considering two columns as two data series the catch to resolve it is after you select cells including all data points formatting the x axis and y axis in excel 2007 charts by greg harvey when charting values excel 2007 isnt always careful how it formats the values that appear on the y axis or the x axis when using some chart types such as the 3 d column ch how to format the x axis and y axis in excel 2010 charts when charting values excel 2010 isnt always careful how it formats the values that appear on the y axis or the x axis when using some chart types if youre not happy with the way broken y axis in an excel chart peltier tech blog you wont find a broken axis tutorial here read why breaking axes is a bad idea and get a tutorial in panel charts an easier more effective way to show data ms excel 2007 create a chart with two y axes and one ms excel 2007 create a chart with two y axes and one shared x axis this excel tutorial explains how to create a chart with two y axes and one shared x axis in excel 2007 with screenshots and step b how to move chart x axis below negative values zero bottom actually we can change the x axis labels position in a chart in excel easily and you can do as follows 1 right click the x axis in the chart and select the format axis from the right clicking men same y axis and different x axis data excel help forum i have tried to plot these two series of data with different x axis and same y axis on the same graph as shown but i cant get it right even when i change primary and secondry axis on grapho doesnt lo how excel calculates automatic chart axis limits peltier excels automatic axis scaling often seems somewhat mysterious and its not easy to find information about it microsoft has a couple articles in the msdn knowledge base how chart ax how to tell excel to plot one column on x axis and another i intend to plot ycoscx in excel where c is a constant produced in first cell of column c using randbetween 5050 column a represents x values from 100 to 123 and column b contains fx cant get evenly spaced chart x axis labels excel help forum i have a simple line chart the x axis runs from 1 50 and the y axis runs from 0 100 i want to put labels every 5 ticks on the x axis but im baffled on how to