Creating a chart with column A as X axis

Hello

I have five columns with values. Column A is the week number. Column B, C, D and E are columns with data from each week.
How can I make a chart where column A is treated as the X axis instead of a data set?

Thanks

Hi
There are lots of ways to do this, perhaps the simplest is the change the chart series formula

a chart series formula takes the format =series(Name,XRange,YRange)

assuming your columns B to E have the series name in Row 1 and data in rows 2:10

1) select range B1:E10
2) create a chart with the selected data
3) in the chart, select the first series. The formula =SERIES(Sheet1!$B$1,,Sheet1!$B$2:$B$10,1) should appear in the formula box
4) edit this to =SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$10,Sheet1!$B$2:$B$10,1)

Tweak the formula if you have more or fewer than 10 data points, or if your sheet's name is not "Sheet1"