Nov 09 2021 05:57 PM
For some reason, I can't figure out how to make a graph/chart in excel based off the data I have for cells B4:B9 and D4:D9. I want the year on the X-Axis and population on the Y-Axis.
Can anyone help me? Need help so I can have this done tomorrow for homework!!!
Nov 09 2021 10:04 PM
@Legionidus Now, I usually don't do homework when posted here, but I assume that your assignment is not about learning Excel. So, this time I'll make an exception. Perhaps you mean a graph like this?
See attached.
Nov 10 2021 04:09 AM
Nov 10 2021 04:32 AM
@Legionidus You could have done that, but since you first year is before 1900, you need to do it like this. Excel can't deal with dates before January 1, 1900. I'm not aware of any other way to create such a chart.
Nov 10 2021 06:02 AM