Can Microsoft Excel make multiple line charts on a shared X-axis?
Microsoft Excel includes several line-chart types for plotting multiple lines on the same chart. But if your data values are not contained in a single table-grid or if you need more control over the format or scale of the X-axis than the line-chart types provide, try the scatter-chart type (specifically, the scatter chart with data points connected by lines either with or without markers). A scatter chart allows you to specify the location of the X-axis values for each data series and includes more options for formatting the X-axis than a line chart.
Last modified on May 11, 2010.







