Excel: Increments on the X axis?

Answer You should not use a line graph. Instead use a Scatter Chart, which will do exactly what you want.

Top Q&A For: Excel: Increments on the X axis

How do I switch the X and Y axis on Excel Excel 2010?

To switch the data between X and Y axes, right click on the chart and choose "Select Data". Use the "Edit" command on each series, and swap the references for "Series X values" and "Series Y values... Read More »

How to Hide the X Axis on MS Excel?

Microsoft Excel charts include portions you may not want as part of your chart. You can remove unwanted portions to create the chart that meets your needs in terms of function and design. One of th... Read More »

How do I create axis bar graphs in Excel?

Excel bar graphs (also called “charts”) are excellent visual aids for comparing values from an “x axis” to a “y axis.” After entering the data that you want to compare on a worksheet, ... Read More »

How to Add a Second Y Axis to a Graph in Microsoft Excel?

It can be very helpful to put multiple data trends onto one graph in Excel. But, if your data has different units, you may feel like you can't create the graph you need. But, have no fear, you can ... Read More »