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 excel 2010 chart does not show x axis value super user in excel 2010 chart data series dont seem to show the x axis value when you put your cursor on a certain data point it shows seriesy axis value pointx axis value and value 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 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 control the x axis start at 62 instead of 0 oz du soleil how do we control the x axis in a line graph and have it start at 62 instead of 0 broken y axis in an excel chart peltier tech blog james good point if my two scales are 0 to y1 and 0 to y2 ill set up the primary scale to y1 to y1 so the data falls in the top half of the chart and the secondary scale from creating an excel chart with two rows of labels on the x axis when the x axis is crowded with labels one way to solve the problem is to split the labels for each data point into two parts and use two rows of labels on the x axis autofit chart y axis dont want it at 0 free excelvba hello i realize this is probably a simple question but i have a macro that analyzes a ton of charts and id like a very very simple fix if possible without vba to be able to auto fit the y axis on how to break chart axis in excel 2003 and office 365 how to break chart axis in excel when there are extraordinary big or small series points in source data the small series points will not be precise enough in the chart multiple axis line chart in excel stack overflow there is a way of displaying 3 y axis see here excel supports secondary axis i e only 2 y axis other way would be to chart the 3rd one separately and overlay on top of the main chart