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.
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.
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks