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
Is there any way of getting Excel to make the y-axis of the spreadsheet (normaly rows) into columns and getting the x-axis (normally columns) to be the rows instead? This would really help in terms of defining fields to be imported into an Access database. 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.
Regards
Simon
