C
connierw
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hello Everyone!
First of all, I'm sorry to be so ignorant with Excel, but I swear I've been trying to figure this out for hours! My eyes already hurt and I'm desperate. So here's my problem. I'm trying to create two excel graphs. They're both line graphs. On one column I have the years (from 1970 to 2010) then on the second column I have the numbers I want to play (pregnancy rates in those years). When using Excel for Office 2008 for Mac, I highlight both columns and it gives me a chart with two lines... It should only be one as the graph's purpose is to show me how the increase/decrease of pregnancy in American in the last three decades... then the X and Y axis are really wrong. The numbers go from 1 to 16 on the horizontal axis when it should be the numbers on of the rates... am I making any sense?
The other graph I'm trying to make is another line graph, but the numbers I need to plot are decimals less than zero (i.e. 0.23, 0.25 etc) and when I try to label the axis, it says the minimum number I can plot is 1.
Someone pretty please help me out! I wish I could print the screen to show you what I'm talking about. I've done simple Excel charts before, but for some reason it's not working at all :-(
Thank you!
(e-mail address removed)
First of all, I'm sorry to be so ignorant with Excel, but I swear I've been trying to figure this out for hours! My eyes already hurt and I'm desperate. So here's my problem. I'm trying to create two excel graphs. They're both line graphs. On one column I have the years (from 1970 to 2010) then on the second column I have the numbers I want to play (pregnancy rates in those years). When using Excel for Office 2008 for Mac, I highlight both columns and it gives me a chart with two lines... It should only be one as the graph's purpose is to show me how the increase/decrease of pregnancy in American in the last three decades... then the X and Y axis are really wrong. The numbers go from 1 to 16 on the horizontal axis when it should be the numbers on of the rates... am I making any sense?
The other graph I'm trying to make is another line graph, but the numbers I need to plot are decimals less than zero (i.e. 0.23, 0.25 etc) and when I try to label the axis, it says the minimum number I can plot is 1.
Someone pretty please help me out! I wish I could print the screen to show you what I'm talking about. I've done simple Excel charts before, but for some reason it's not working at all :-(
Thank you!
(e-mail address removed)