How to Make a Graph in Excel With Two Separate X Bars

Make a graph in Microsoft Excel with two separate "x" bars to display two different data sets within the same graph interface. Excel creates graphs and charts based on data you input into spreadsheets. If you input data into two separate sets of columns, Excel interprets this as two separate graph plots, which you have the option of displaying together as part of a single graph.

Instructions: 1. Open Microsoft Excel. Click the "Folder" icon to open an existing spreadsheet if you need to create a graph from existing data.
2. Type or paste your first set of "x" data into column "A" and the second set of "x" data into column "D." Input or paste the corresponding "y" data into columns "B" and "E." Leaving column "C" blank prevents Excel from interpreting the four columns of data as being part of the same data set.
3. Hold down the "Ctrl" key and click each of the cells you want to be part of the graph. Move your mouse over the "Charts" pane and click the drop-down menu under the type of graph you want to create. Click the type -- examples include "Line" and "Scatter" -- you want to create to display the two data sets within the same graph or chart.