View Full Version : Charting on Excel


Kasie
June 13th, 2004, 12:04 AM
Has anyone tried charting on their Excel software. I really don't have a need for Fertility Friend and the like, I just want to see patterns. So if you have done this can you teach me how??? Or direct me to some sort of instructions for the excel illiterate.

TIA

Nocona
June 13th, 2004, 11:09 PM
Has anyone tried charting on their Excel software. I really don't have a need for Fertility Friend and the like, I just want to see patterns. So if you have done this can you teach me how??? Or direct me to some sort of instructions for the excel illiterate.

TIA
Ok, I'll give this a try explaining it....

Open a new excel document
Put your cycle day #s across the first row
Add your temps across on the second row, corresponding to each cycle day
Then hit the button called "chart wizard".. it looks like a column chart
Then select the tab that says "custom types" (there's a standard and a custom tab)
Then select "lines on 2 axes"
Then click next
Then on step 2 of 4 of the wizard, it will give you 2 tabs... data range and series. On data range, select (in your excel file) the row with your temps. Then click "next"
Then click finish and it will make your chart.

I hope that works for you. I did it as I wrote this and it worked.

Kasie
June 14th, 2004, 11:05 PM
Thanks Nocona,
I'll give it a try here in a few...I actually have to take a temp first. http://smileys.smileycentral.com/cat/4/4_1_72.gif (http://www.smileycentral.com/?partner=ZSzeb001)

Nocona
June 15th, 2004, 08:44 AM
:lol: yea, that would help :lol: