When selecting data for use in an Excel scatter chart the default column/row assignments are that the first column/row will be used for the X axis and subsequent columns/rows will be used for the Y axis. For example, if there are five columns of data selected, the first column is the X axis and columns two, three, four, and five are the Y axis (series 1, series 2, series 3 and series 4). Is it possible to reverse the default assignment so the first column is the Y axis and subsequent columns are used for the X axis? So for five columns, the first column is the Y axis and columns two, three, four, and five are the X axis (series 1, series 2, series 3 and series 4).
I've just tried to create a chart from the data layout you describe. There is no switch you can set in Excel to use the first column as the Y value and the second and following columns as X values. You can insert an empty XY chart and then manually add the data series. The data layout with the Y in the first column is so unusual that it took a lot of concentration to get the chart right. I'd prefer to re-arrange the data to follow Excel's logic of the data layout rather than work against Excel. The screenshot shows a chart that can be manually stitched together by defining each series by hand, or, using the lower data layout, with one click.
I have Excel 2000. I right click on the chart, click
I believe that Kitet may have been partly right. Is this the sort of thing you want?
I started out small and did this:
by entering the data, creating the chart, right-clicking on the curve, and selecting “Select Data…”:
That gave me this “Select Data Source” pop-up:
where I clicked on “Edit”. That gave me the “Edit Series” dialog box, and I just changed all the
The one with the two
This is on Excel 2007.