Hello, I am new to this forum. I am a student doing research for a professor right now about teenage pregnancy, dropout rates, and crimes. I have made several graphs to show the trends of these three categories. My professor wants me to put...
Hello,
I am new to this forum. I am a student doing research for a professor right now about teenage pregnancy, dropout rates, and crimes. I have made several graphs to show the trends of these three categories. My professor wants me to put all these three graphs into one so he could see how they compare to one another.
My question is what is the most effective way to do this? I've tried copying just the trend line (e.g., of violent crime) and putting it into the pregnancy graph, but that was not possible. I cannot put all the data into one excel sheet because the rates are different. For example, teenage pregnancy rates are 80.1 per 1,000 teenagers while property crime is 3,000 per 100,000 teenagers. Basically, I just want a very broad stroke of what the trends looked like in the past 40 years without any specific data.
It would be best if I could copy one trend line and paste it to another graph. I tried using the paste special but that did not work as well.
Any help is greatly appreciated. I've attached the two graphs to help you understand better. Thanks so much!
Sincerely,
Cammie
Attached Files
arrests.xls (84.0 KB)
birth rates.xls (48.5 KB)
Linear Mode
