Hi Guys,
I have stumbled across this forum as a result of owning excel 2007 , i have a major report due in on a river flow analysis, i have obviously got to produce graphs representing flow rate and this is the first time i have used excel 2007. Basically i need to switch the X and Y axis around but really cant work out how to and i have just spent over two hours trying.
The graph type is a standard line graph; i want my cumulative frequency (which is just a % of 0 - 100) on the Y axis and i want my mid points (just numbers from 1 to 37) on my X axis no matter what i do excel keeps putting them the other way around and making the graph ranges to its own liking (i.e. its not stopping at 100% it goes to 110 etc) I cant move the data as its enbedded into formulas. Please Please help me as im so very stuck on this and really do not know what else to do!!!
Thanks (im going to sit here refreshing the page for a reply)
Sam
Bookmarks