I want to create a chart that shows the highest given value for each day (regardless of which hour it occurred) and another chart with the highest given value by hour. In the above sample the chart would show:
10/01/09 56.7
10/02/09 44.5
10/31/09 56.6
12:00am 56.5
01:00am 44.5
02:00am 17.5
I am able to do this in excel very quickly by using a Pivot Chart, but can't seem to figure this out in Numbers.
Got Numbers 08 installed, never really used it as didn't have a need. Created a spreadsheet the last day with some survey results for a project and saved it.
My spreadsheet looks like: (A1-Grey) - Sex - Age - Multiple choice question (Blank-Grey) - Male - 30 - Answer1 (Blank-Grey) - Female - 25 -Answer2
With a blank column on the left that's grey and the top heading thing being grey. Bit lost though with turning say the "Multiple choice question" column into a pie-chart (or any sort of chart tbh). I choose the header and all the 30 or so replies in that column and select chart -> pie-chart. It presents me with a pie-chart "Chart1" with just blue - 100% and the legend stating : blue - Untitled 1. How would I go about making the chart with the data I need? (I know I'm selecting it wrong or have it laid out wrong or something) or editing a chart manually.
Can anyone tell me how to make a pie chart in Excel 2008 that uses different styles of black and white cross hatching for each slice. Its carefully hidden in Excel 2007 as a custom style, but I can't find a way of doing it in Excel 2008.
I'm new to the Mac world but have been successful in creating a few Automator workflows to simplify certain tasks. However, I'm stuck on the flowing; I'd like to create a workflow that searches a particular folder for items created 30 days before today's date and the delete them. I'm assuming I need to create a variable of today's date and then subtract 30 days from it and so on. Haven't been able to figure this out.
I'm trying to insert an organizational chart into an existing Word document that has track changes. I went to SmartArt Graphics, and clicked on Hierarchy, but everything is grayed out. This document is originally from a PC.
I am trying to create an organizational chart on my MacBook Pro. Is this possible without downloading something that costs money? Are there any free resources to use?
I am on Tiger 10.4.11 on Mac Book Pro Intel duo. All updates except for Parallels installed. Have run permissions repairs and preferential treatment. Tried to delete preferences for system ... Every time I try to uncheck the box marked or open the Date and Time preferences, it freezes and have to force quit.
So I shut down my computer earlier today for the first time in weeks. I restarted it and then left for a few hours for dinner.
I come home and I look at the last time MobileMe Sync and Time Machine did their things. They say they did them at 7:45. I look at the clock on my cable box and on my iPhone, both say 6:45.
Weird that the MacBook's time is wrong. I go into Time Date settings. I see that when the MacBook does the "Auto locate where you are so that we can set the appropriate time zone, etc. the MacBook things I'm in Rexford, Idaho.
I haven't been to Idaho in about 25 years, and my MacBook has been sitting in Southern Kalifornia for the last one year since I bought it.I've tried to have the MacBook auto-locate again, and it keeps finding me us in Rexford, idaho.
I'm running OSX 10.5.8 on a G4 iBook. Somehow my Time & Date files got corrupted which prevented me from getting on to the internet. When I discovered the problem, I threw them away, thinking a restart would create them again. I was wrong.
Now my computer doesn't know what time or year it is, causing various problems. I don't have back-up 10.5 disks to extract the time & date package.Can I download a replacement anywhere?
Or can someone email the files to me? I don't know what they're called but, if you search time and date, there are only two (and please tell me what folders they're in too)
Starting yesterday, I cannot load Time & Date (either from System Prefs or from the menu bar). I get the beachball and I have to Force Quit System Prefs.
I tried Repairing Permissions and rebooting but it didn't help.I tried deleting .plist entries (as per a related thread on the Internet) and rebooting and that didn't work either.I tried logging off and logging in with another account and the problem is still there.I hope I can get some help because it's driving me nuts. I travel a lot and need to change my time zone. If you need a crash report from me, please tell me how to get it from Console bc I don't know where to look for it!
My date and time resets each time my mac sleeps or is reset or if I open date and time options. It keeps sending emails of my old reminders from 2008/2009 from ical and my to-do list emails me its reminders. This happens every time I open my comp or even just open date and time options. I also get the ical reminder notification that pops up freezes on my screen.
For quite a while, any Java based applications on my Mac have been taking a long time to launch. When I start them, the icon just bounces on the dock for about 2 minutes and then once it stops I force quit it, start it again and it loads fine. I have the same problem with both Minecraft and Angry IP Scanner so I'm near certain that it is not application specific. All other applications load almost instantly and there is plenty of memory available (8GB installed) for them to launch. Just for reference: all of the updates available on Software Update are installed as well.
Info: Mac mini (Mid 2010), Mac OS X (10.7.3), 2.4GHz Core 2 Duo, 8GB DDR3 RAM
I'd like to insert the Date in the appropriate space on a letter. It seems that I cannot do this without inserting the day of the week and the time. When I look for a way to change this format, it seems that iPages only instructs me on how to change it when I am using the date/time in a cell in a table. How do I do it for a plain old letter?
I do video depositions which requires me to place the date and time on my video when the video was shot. Currently I have to ingest my video into a Windows computer and run it through a time stamping program called VTS DV timestamp [URL] This program is awesome other than the fact I have to use Windows. I would like to use nothing by my mac but alas, I have not been able to find a program that works. FCP time code generator does not work like I want it to.
I'm looking for a program where I can enter a date and time and it will calculate the amount of time until that date and display a countdown until that date and time. Does such a program exist? I've googled with not much success.
My G5 OSX 10.4 on restart displayed the date&time error message (attached). And yes it was causing my applications to run erratically, such as not loading. After updating the time both manually or automatically, on restart time would revert to 1970 with the error message re-appearing. I erased my hard drive tried to install OSX 10.5.1 1st attempt it was unable to locate my hard drive for install location, it simply paused. 2nd attempt it located drive, but during install white page full of errors appeared. 3rd attempt it appeared to install fine. But again on restart the date time error message appeared, time set to 1970. Updating time didn't help. I upgraded OSX 10.5.1, during install it displayed an Update OSX error message (attached). After this error message I restarted but I can't get past the grey loading screen. If it helps here's what im running:
Model Name:Power Mac G5 Model Identifier:PowerMac7,3 Processor Name:PowerPC G5 (3.0) Processor Speed:2.3 GHz (Dual-Processor) Number Of CPUs:2 L2 Cache (per CPU):512 KB Memory:512 MB Bus Speed:1.15 GHz Boot ROM Version:5.2.4f1
My date and time resets each time my mac sleeps or is reset or if I open date and time options. It keeps sending emails of my old reminders from 2008/2009 from ical and my to-do list emails me its reminders. This happens every time I open my comp or even just open date and time options. I also get the ical reminder notification that pops up freezes on my screen. Not sure how this happened, but can anyone help?
I'm playing around with the charts in Pages (which are freaking awesome, btw). But I can't figure out how to get a pie chart without the colour purple in it--see some screenshots below. In the first screenshot you'll see the legend under the chart, with untitled purple and blue markers. If I try to delete these markers (see second image), then all the markers will shift, so that the first two are always purple and blue ! Is there a way to get rid of purple and blue altogether? Or just not show the untitled markers? Or does everyone actually like purple? I think it's a pretty horrid colour for a chart.
So I'm creating a chart to show Uk carbon emission targets. I realise that the total percentage will not equal 100% but that's not the point of the chart. Although the data is correct, the figures on the chart itself is not correct. Is there a way that I can override the figures on the chart? If not, how can I make it match the table data but ignore the 100% rule?
Is there any such software for the Mac? My windows system just blew up and I really need to get back in to trading (without windows this time hopefully).
I have a mid-2008 (June) MBP 15". Just upgraded to SL last night. I am having a serious issue with time machine. I've been using it with the same external HD since I bought my mac last year. No issues up until I installed SL last night. This morning (my first backup since upgrading), time machine started backing up (~ 9Gb) but just stops at around 300Mb. The clock keeps spinning, but there is no change in the amount backed up.
I'm reading that other folks are having this issue as well. Has anyone figured something out?I've run disk repair (nothing found), restarted my mac & external HD (several times each), and cancelled and restarted the time machine backup (several times). Each time it freezes at a different amount (i.e. 34Mb, 284.2Mb, etc...).
I was wondering if anyone knew why ITunes takes forever to make an "ipod/iphone" version of a movie from the advanced menu? It seems like when i use mpeg stream clip or another video converter it is much quicker.
I am working on a MacBook Air (purchased Oct 2009) running Lion. While working in Excel 2011, I encounter the error "Some chart types cannot be combined with other chart types. Please select a different chart type." I am highlighting 46 cells to create a marked line graph. There are no other charts in the file. I called Microsoft support who told me they had not heard of this problem in Excel (only in PowerPoint). I also took it to an Apple Store Genius, who was unable to solve the problem, which is understandable, given that he does not work for Microsoft. Â
I have recopied the data to a new spreadsheet, re-typed all the data to a new spreadsheet, and deleted plist files. When I sent it to a different computer (which was running Excel 2011 and Snow Leopard), I could make the figure but I cannot edit the figure or add data on my laptop.Â