Results 1 to 5 of 5

Thread: Excel help - two units at a y-axis

  1. #1
    Join Date
    Mar 2009
    Posts
    34

    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?

  2. #2
    Join Date
    May 2008
    Posts
    4,345

    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

  3. #3
    Join Date
    Mar 2009
    Posts
    34

    Re: Excel help - two units at a y-axis

    Thank you although it looks somewhat cumbersome off...
    What about Excel 2003, which I use?

  4. #4
    Join Date
    May 2008
    Posts
    3,316

    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.

  5. #5
    Join Date
    Mar 2009
    Posts
    34

    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.

Similar Threads

  1. Replies: 3
    Last Post: 25-02-2012, 12:25 PM
  2. Y axis label cutoff in Excel graph
    By Hache hi in forum MS Office Support
    Replies: 2
    Last Post: 25-02-2012, 11:47 AM
  3. How to fix a broken Y axis is Microsoft Excel
    By Bala!aditya in forum MS Office Support
    Replies: 5
    Last Post: 21-01-2012, 04:42 PM
  4. Data points in Excel chart not lining up with axis
    By mbbackus in forum MS Office Support
    Replies: 1
    Last Post: 10-01-2012, 11:58 AM
  5. Switch axis in excel 2007
    By squall_leonhart69r in forum Windows Software
    Replies: 3
    Last Post: 11-06-2009, 01:46 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,693,804.42617 seconds with 17 queries