Excel help - two units at a y-axis
Hey geeks.
I stand in the situation that I am doing a job that provides little financial management. I have compiled a few key figures for an accounting firm, which went fine. Now comes the problems of temporary make the graphical presentation order in Excel.
I have some turnover, number of full time mf all of which are in absolute numbers, which can easily be displayed in the same graph. Problem is now that I would have shown those graphs with such a Graph Development of return, debt ratio, etc. all of which are in %.
Together Makes you just direct them to, Excel mess up because it did not know whether you want the y-axis in percentage or plain figures. Is there a way to make the unit on the y-axis on the right hand portion of the graph so that it can have both with me?
So figure on the left as normal, and percent number in the right part?
Anyone?
Re: Excel help - two units at a y-axis
Excel: Create a chart with two Y-axes and one shared X-axis in Excel 2007
http://www.techonthenet.com/excel/charts/2_y_axes.php
Re: Excel help - two units at a y-axis
Thank you although it looks somewhat cumbersome off...
What about Excel 2003, which I use?
Re: Excel help - two units at a y-axis
First you select the things to be on the x-asks. Then release button and then hold ctrl key while you select what you want on the y-axis.
It should work, but sometimes messing also suffered very much with me. But is learning what is a physics lesson is obsessed with graphs, ALT just signed as a graph, and then you can read. If you do it otherwise you get shit nature of delivery and reports.
Re: Excel help - two units at a y-axis
Thanks for any ideas and so on, but took himself out of it (the easiest way). Select what you want. Select chart custom type curve with two axes. Done.
Not quite the same freedom of choice, but it is faster and easier - do not want to hassle with it for more.