Link to home
Start Free TrialLog in
Avatar of Ron Bayes
Ron Bayes

asked on

Excel Age Projection Line Chart

Hello,

Looking for guidance on creating an Excel chart based on projected age.  I have a basic employee table where each row represents an employee.  In one column I have employee age as of today.

What I'm looking for is a line chart with one line showing a total count of employees under the age of 60 and another line showing employees age 60+.  The two axis would be employee count and year.  The chart would start today and then project to 2028.  So what you should see over time is the age 60+ go up as employees get older while the below 60 will decrease (see image sample).

Thanks!User generated image
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Can you upload some sample data? Please remove any real names as the data will be publicly visible.
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ron Bayes
Ron Bayes

ASKER

This was helpful and put me on the right path.  Thanks.
Thanks for the feedback. Happy to help further if required.