Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel changing spreadsheet axis

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel changing spreadsheet axis

Excel changing spreadsheet axis

ResolvedVersion 2007

Edgar has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access VBA course

Excel changing spreadsheet axis

I'm not sure if my first post went out as I can't see it on the Forum. Is it possible to get Excel to change the spreadsheet axis, i.e. get the y axis (usually rows) to become the columns and get the x-axis (usually columns) to become the rows? This will help me in terms of defining the fields of a form when importing the data into Access.

PS I have already been on Excel courses and there was no time to cover this.

Thanks.

RE: Excel changing spreadsheet axis

Hi Edgar,

Thank you for your question.

If you mean switching the data plotted and make the verttical to horizontal and vice versa, then go to the Chart Tools ribbon and then click the 'Switch Row and Column' button on the Data tab. This will switch the values of the axis.

Alternatively, you will have to define the series for each axis yourself via the Data tab. See if the folowing links help you at all.

http://office.microsoft.com/en-us/excel-help/change-the-display-of-chart-axes-HP010342246.aspx

http://www.excelbanter.com/showthread.php?t=207494

I hope this helps.

Let me know how you get on.

Regards

Simon

RE: Excel changing spreadsheet axis

Thanks for getting back Simon. I'm not interested in changing the axis of a chart, I am more interested in knowing how to define axis on the actual Excel spreadsheet so that I can define exactly what fields get imported into an access database. Do you have any links or information resources I can look at to help me do this? Thanks.

Best regards,

Edgar

RE: Excel changing spreadsheet axis

Hi Edgar. There is no way to physically change the axis of an entire spreadsheet. However, what you are trying to do sounds an awful lot like transposition. If you select your data, copy it and then select a blank cell elsewhere, choose Transpose from the Paste dropdrown on the Home menu. This will "spin" your data. You will have to do this prior to use in Access if your fields are rows instead of columns, and if you want to skip this step you're looking at a code solution.

Hope this helps,

Anthony

RE: Excel changing spreadsheet axis

Thanks Anthony,

That's pointed me in the right direction, will look into codes regarding transposition.

Edgar

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.