Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Help on Excel 10 graphics.


05 Jun 2012   #1

Windows 7 Home Premium 32bits
 
 
Help on Excel 10 graphics.

My doctor asked me to annotate (during one month time) dates and times of readings taken from my glycemic tests.
In some days, I have two or three readings at different times.
How can I display these three variables (date, time and readings) on my MS Office (Home & Business 32 bits) Excel 10 graphic?
Any help is welcome.
Flores

My System SpecsSystem Spec
.

05 Jun 2012   #2

Win7-64
 
 

That is an interesting problem. You will need to use a 3D column chart. One axis (X, from left to right) should be the day, the next axis (depth, meaning front to back or "into" the screen) should be the time, and the 3rd axis (height) should be the glycemic reading.

The biggest problem will be orienting the chart so you can see all the readings. Taller ones in front will hide shorter ones in back but you can usually get around this with the proper rotation, although this will take some fussing. You can rotate the chart view in any direction so the proper orientation is going to depend on what your readings are like and how many in each day there are.
My System SpecsSystem Spec
05 Jun 2012   #3

Windows 7 Enterprise x64
 
 

You would only need three axes if you treat date and time of day as separate variables. I would instead treat time as a single variable. To do this, you'll need to use your dates and times of day to calculate a single figure representing time. The method below will give you time in days since the first reading, so the graph will start at time zero:
  1. Format the first column (Column A) as dates.
  2. Put the dates of the readings in that column.
  3. Format the second column (Column B) as times.
  4. Put the time of day (using the 24 hour clock) in that column.
  5. Format the third column, Column C, as numbers with two decimal places.
  6. Use this formula in the first cell in Column C:
    =(A1-$A$1)+(B1-$B$1)
  7. Drag the corner of the first cell down Column C until there is a value for every date/time pair.
  8. Put the blood glucose readings in Column D.
  9. Select Column C and Column D and insert the chart of your choice - I would suggest a 2D line.
  10. There you go

I have attached an Excel file that uses this method to draw a graph of glucose readings against time (using made-up data!).


Attached Files
File Type: rar Glucose Example.rar (5.6 KB, 15 views)
My System SpecsSystem Spec
.


06 Jun 2012   #4

Windows 7 Home Premium 32bits
 
 

Quote:
.....The biggest problem will be orienting the chart so you can see all the readings.
Hello bbinnard,

Thanks for the help.
I will experiment adjusting the chart so all readings will be available for my doctor to see.

Cheers,
Flores
My System SpecsSystem Spec
14 Jun 2012   #5

Windows 7 Home Premium 32bits
 
 

Hello clunkfish,

I'm having some difficulties adapting to the suggested method.
Give me some more time.
Thanks a lot.
Flores
My System SpecsSystem Spec
14 Jun 2012   #6

Windows 7 Enterprise x64
 
 

Hi Flores - please do feel free to send me data and I will set up a spreadsheet for you, if that would help?
My System SpecsSystem Spec
15 Jun 2012   #7

Windows 7 Home Premium 32bits
 
 

Quote:
..... - please do feel free to send me data and I will set up a spreadsheet for you, if that would help?
Hello clunkfish,

I'm quite sure I will need your further assistance.

Many thanks,
Flores
My System SpecsSystem Spec
16 Jun 2012   #8

Windows 7 Home Premium 32bits
 
 

Quote:
please do feel free to send me data and I will set up a spreadsheet for you.....
Hello clunkfish,

Attached please find the spreadsheet made in accordance with your instructions.

The problem is that the days are not showing up, only the times.

On some days I have more than one sample taken.

Regards,
Flores
Help on Excel 10 graphics.-glucose.jpg


My System SpecsSystem Spec
18 Jun 2012   #9

Windows 7 Enterprise x64
 
 

Hi Flores,

I think there must be a flaw in your formula. I have inserted your data in my worksheet and get the chart below, with the horizontal axis in days, as required:


Attached Thumbnails
Help on Excel 10 graphics.-glucose.jpg  
My System SpecsSystem Spec
19 Jun 2012   #10

Windows 7 Home Premium 32bits
 
 

Quote:
....I think there must be a flaw in your formula.

Hi, clunkfish,

Yes, the formula was wrong, but corrected now.
Still, column "Time(Days)" differs from yours.
Cheers,
Flores


Attached Thumbnails
Help on Excel 10 graphics.-glucose.jpg  
My System SpecsSystem Spec
Reply

 Help on Excel 10 graphics.




Thread Tools



Similar help and support threads for2: Help on Excel 10 graphics.
Thread Forum
Enabling onboard graphics/Disabling graphics card method Graphic Cards
Solved New Graphics Card new Event Viewer entries (NOT graphics related??) Performance & Maintenance
play high graphics games without graphics card Gaming
Formatting Excel 2010, Excel 2003 Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 05:58 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33