Graph problem in excel...
View Full Version : Graph problem in excel...
Jessica
March 17, 2010, 02:25 PM
For a project at school I have to construct 2 graphs. About 2 months ago I did a similar project with using graphs and all that.
well the problem is the date and time for this project is completely wrong, I have the time as 3/--/10 2:00 AM or PM and it shows 3/--/10 12:00 AM/PM. No matter WHAT I do, it doesn't change at all....
now for the previous problem I did not have that problem at all. It was a dual axis graph I'm not sure if it's because of that, that is making the problem....
How do I solve this? I need to fix it by Friday, and I have no idea how. the graph looks weird and confusing
(for people who are good with Microsoft Office problems.....)
CrOtALiTo
March 17, 2010, 04:49 PM
Have you checked the time setting of the windows, sometimes the time of the windows if it's not change or correct with the time of the country tend to be errors in the software.
chileno
March 17, 2010, 05:05 PM
For a project at school I have to construct 2 graphs. About 2 months ago I did a similar project with using graphs and all that.
well the problem is the date and time for this project is completely wrong, I have the time as 3/--/10 2:00 AM or PM and it shows 3/--/10 12:00 AM/PM. No matter WHAT I do, it doesn't change at all....
now for the previous problem I did not have that problem at all. It was a dual axis graph I'm not sure if it's because of that, that is making the problem....
How do I solve this? I need to fix it by Friday, and I have no idea how. the graph looks weird and confusing
(for people who are good with Microsoft Office problems.....)
Check what crotalito told you and also use the format cell option, either by way of drop down menu or by right clicking the cell and a menu will be present there with the "format cell" option.
CrOtALiTo
March 17, 2010, 05:23 PM
Check what crotalito told you and also use the format cell option, either by way of drop down menu or by right clicking the cell and a menu will be present there with the "format cell" option.
Yes is it in the part of the excel's menu, you there in the part where says format there are where you can change the time format for complete.
But you should to check first the time settings of your windows.
Can I be at most sure that the trouble start for there.
Jessica
March 17, 2010, 07:10 PM
I did that, it doesn't/didn't change
Anyways I already found the problem, I had to select Text Data
thanks anyways guys
CrOtALiTo
March 18, 2010, 09:39 AM
I believe that you can try to reinstalling the software again, you don't need to uninstall the software completely, only you need to enter to the control panel to the part where you add or remove programs, and you select the office 2003 or office 2007, and you give click in the change, there the software will asking you, if you wist remove or modify the software.
Then you select modify the software, later it asking you if you want find errors in the software and fix them, you give click in that feature and well just the software fix the troubles that currently has.
I hope that you can fix you problem.
Jessica
March 18, 2010, 10:22 AM
I already did
I am using Office 2010 beta
CrOtALiTo
March 18, 2010, 01:53 PM
Then you have troubles with your windows.
Please if you can take it with a IT support, it should be better that you're divining the it could has.
AngelicaDeAlquezar
March 18, 2010, 04:20 PM
@Crotalito: Jessica dice que ya está resuelto. :)
Jessica
March 18, 2010, 07:53 PM
I don't have the problem anymore, I fixed it. It was only a small problem. And Office 2010 has nothing to do with it :P
CrOtALiTo
March 18, 2010, 08:26 PM
@Crotalito: Jessica dice que ya está resuelto. :)
Angelica ella solo dijo ya lo hice.
Where she said that it was ready.
AngelicaDeAlquezar
March 18, 2010, 08:39 PM
I did that, it doesn't/didn't change
Anyways I already found the problem, I had to select Text Data
thanks anyways guys
El texto que resalté en rosa, dice "Gracias, ya encontré el problema, tenía que seleccionar Text Data. Gracias de todas maneras".
vBulletin®, Copyright ©2000-2025, Jelsoft Enterprises Ltd.