Modify X-axis coordinates for several curves

Hello everyone!

I apologize for the noobish question, but I just can't seem to figure it out.

I would like to plot several curves into one same chart. For example, I have a list of students who each start with 100$. They sell and buy small stuff and we check again their money at given timepoints (which might not be the same between each student).

Student	Timepoint 1	Timepoint 2	Timepoint 3	Money at timepoint 1	Money at timepoint 2	Money at timepoint 3
1	0	7 days	14 days	100	90	94
2	0	8 days	15 days	100	80	90
3	0	7 days	15 days	100	85	86

Now if I plot all the money cells and open the data box, I can modify the source of the X-axis data, but it affects the whole series altogether. Image1.png

How can I change the X-axis values (the dates) for each series by its corresponding line? In my example, I would like to select B2 to D4 and have it correspond automatically to the E2 to G4 cells.

Does this make sense?

I thank you in advance!

What chart type are you using? It should be straightfoward to edit each series to have a separate x axis range when using an XY scatter chart. I find it more difficult with other chart types.

I'm using 2-D lines. Ideally I wouldn't want to edit each series separately to input the X-axis values manually, because I have many series.

I guess my problem arises from the fact that having so many lines on a same graph is usually a bad idea because everything gets messy, but in my case I'm trying to show that all the curves have the same tendency.

Here is the example from above. I am trying to use the cells circled in blue as X-axis coordinates for each series. If I click on "edit" in the red circle, it only changes the X-axis coordinates for all the series at the same time.

example.jpg

I'm using 2-D lines.

In my experience, line charts and others that use a category axis do not handle multiple x values ranges well if at all. Unless you want to make some major changes to the way your spreadsheet is arranged (see below), then you will want to use an XY scatter chart for this (you might want a scatter chart anyway, if you want your X values to be treated as numbers in the chart).

Ideally I wouldn't want to edit each series separately to input the X-axis values manually, because I have many series.

Excel does not know how to automatically parse data into chart ranges the way you have it arranged. If you want to keep the same arrangement in the spreadsheet, then you will be required to edit each series separately (or write a VBA macro to do the same). If you want Excel to be able to automatically parse the X and Y data ranges, you will need to arrange the data with a single column (row) of X values and multiple columns (rows) of Y values:

Please Login or Register  to view this content.

How would you like to proceed? Rearrange the data in the spreadsheet so Excel can automatically parse the data ranges? Or edit each data series individually while keeping the current arrangement? (I'd switch to a scatter chart, in either case).

In a scatter chart, the x values range is part of the edit series dialog. In the "Legend Entries (Series)" box, select a data series, click on the "Edit" button at the top of this box, and a dialog will come up that shows fields for series name, x values, and y values. You can then edit you x values range in this dialog.