Rotate chart\axis

[largeinnit]

Hi,

I'm trying to show a correlation between moisture content and depth which can be shown better if i rotate my graph. I haven't found any way to do this in Excel though.

Below I have included some files:

1. Excel spreadsheet xp - http://homepage.ntlworld.com/daniel....t/moisture.xls

2. Current graph (jpg)- http://homepage.ntlworld.com/daniel..../realgraph.jpg

3. the format i want graph in - http://homepage.ntlworld.com/daniel....hart/graph.jpg

thanks in advanced

large

[mangesh_yadav]

Go to your graph. double-Click on X-axis, or right-click and then select FORMAT AXIS. Select the SCALE tab. You will find the option VALUES IN REVERSE ORDER (second line from last). Check this option. Repeat with Y-axis

- Mangesh