+ Reply to Thread
Results 1 to 2 of 2

sales growth vs. headcount growth for recent years

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    sales growth vs. headcount growth for recent years

    Hello. I have sales numbers for past 3 years (in 100,000's) and headcount numbers for past 3 years (in 100's). How can I compare these numbers in the same chart? I thought of a secondary axis but the scales don't make sense.

  2. #2
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: sales growth vs. headcount growth for recent years

    Hi Amma,

    You can take Headcount on secondary axis and can change the chart type to Line.

    Sales vs HeadCount.PNG

    EDIT : You can change the scale as per your trend. I have just included the image for your reference so you can get an idea.


    Cheers!!!


    Anil
    Last edited by adhawan06; 04-15-2015 at 04:28 AM.
    Thanks,
    Anil Dhawan


    Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.

    Don't stop when you are tired. STOP when you are done!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. create chart for customer growth vs. expense growth
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 04-06-2015, 01:19 PM
  2. optimizing sales growth
    By ammartino44 in forum Excel General
    Replies: 2
    Last Post: 11-05-2014, 06:59 PM
  3. Percentage Growth between two years
    By debbiesap in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-27-2014, 08:59 AM
  4. Interpolate monthly growth from known Annual Growth
    By nopointing in forum Excel General
    Replies: 3
    Last Post: 06-15-2014, 03:36 AM
  5. [SOLVED] headcount growth maybe nested if funtion??
    By taxcrazy99 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-26-2013, 09:47 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1