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.

19 Jun 2012   #11
clunkfish

Windows 7 Enterprise x64
 
 

Well, that's what I mean. The correct formula, as in the Excel spreadsheet I provided, will give the correct data, as in the image I uploaded. Because your Time(Days) column contains the wrong values, you must have the wrong formula...

If you just enter your data into the spreadsheet I provided, without changing any formats or formulas, it will work


My System SpecsSystem Spec
.
19 Jun 2012   #12
amflores

Windows 7 Home Premium 32bits
 
 

Hi clunkfish,

I think I'm missing something from your teachings.
Please, check the formulas and formats on my attached zip file.

Regards,
Flores


Attached Files
File Type: zip Glucose Samples.zip (11.1 KB, 2 views)
My System SpecsSystem Spec
19 Jun 2012   #13
clunkfish

Windows 7 Enterprise x64
 
 

Problem identified

Your Time(Days) column is formatted as time, when it needs to be formatted as number. If you highlight the cells, right-click, go to "Format Cells...", then choose "Number" from the list of categories, the values under Time(Days) will change to the correct ones.

You also need to change the chart type, so that the values on the horizontal axis are arranged correctly. Just right-click the chart, choose "Change Chart Type...", and select "X Y Scatter". I think I had that wrongly set up in the original spreadsheet

Hope this helps you to make the chart you need.
My System SpecsSystem Spec
.

Reply

 Help on Excel 10 graphics.




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
New Graphics Card new Event Viewer entries (NOT graphics related??)
I usually make a habit of checking Event Viewer (EV) on a regular basis, having installed new drivers and a new graphics card this morning, without a hitch, I decided to check EV since this was a rather big change to the system. Sure enough there was some new entries. However when I looked into...
Performance & Maintenance
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
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 13:10.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App