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