Applications :: Trying To Create Pie Chart (Based On MCQ) In Numbers
Mar 1, 2009
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.
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.
I have no experience in Numbers so I was wondering if I could create a histogram in Numbers and then bring over the histogram chart over to Pages? And how would I do that exactly? Can that be done? I need to do something like this so that my lab report for my Physics class could look a bit better typed and everything and without any sort of glue or tape.
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.
Does anyone have a link to a chart of the various screen resolutions and their corresponding dpi numbers? I have been trying to find one and have been woefully unsuccessful thus far. I would just like to compare the different resolutions of computers I have, and have used, vs. the new mpb resolutions.
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'm sure this is easy to answer by someone with basic spreadsheet skills, which I lack... I have a column of numbers (miles) and a column of use (Personal, Medical, Business). How do I set up 3 formulas so that I get the sum of the mileage column for each of the Personal, Medical, and Business categories?
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've been ripping my hair out trying to find the answer to this.
In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.
For example:
Column A - 1 - 5
Column B - (value in Column A * 5)
I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.
The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"
See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.
like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.
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 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.
I am working on my thesis data where I have to create a lot of different graphs, all of which have cells where there was no sampling done and thus, no data. I would like to display a symbol or indicator in the graph where there is no data rather than it appearing as a zero value. I do not want to go through after creating the graph and importing it into my word doc and place text boxes with symbols where there is no data.
I need to create a timeline for a project, it needs to show a list of releases of different products, I also need to be able to create one that shows how these items can run parallel to each other. Is there anything that would be suited to the task? (a free solution is best, I only need to use it this one time).
Anyone know of software that looks like a Yearly planner. You know, like a each month of the year mapped out and you can colour them differently or block out certain weeks to signify something important. I know I can use ical but I want to be able to block out things and see the year at a glance.
Looking for a web based interface with Mac. A Go To My Mac if you will. I was wondering if anyone knows of one or how to jury rig mac OS X into doing this? (the best solution I came up with was to share on my mac using VNC software and then GOTOMY PC to the windows machine.
Thought I would take a couple minutes to summarize my thoughts on the Macbook Air after 3 months of use. For comparison, my prior machine was a Sony Vaio TR Series machine that I had for 4 years. I use the machine primarily for web-based applications, and Microsoft Office applications.Overall, I would buy again, but there are a few pros and cons I would point out. For most of what I do, it works fine. But if you are routinely using a lot of applications at one time, or working with large programs, I?m not sure it would be for you. If you buy, get the external DVD drive. You won?t use it that much, but it will be useful for installing software. While cool, the remote-disc feature makes these tasks more complicated than they need be, particularly when it?s only a $99 added cost.
I consider myself pretty savvy and this problem arose when I tried to add my school's email to Mail.app... I took my computer into the Apple store and they were unsuccessful after about an hour of trying.
Now, I've read on Titan Apps (the section on the CSUF school portal) that you have to create a password solely for POP/IMAP access, and I did that, and I made a new Mail account with the new settings and I'm still receiving errors about the password not being right to get new mail.
I'm sure this has been asked before so please forgive me. I have found arguments that say just use Migration assistant to some saying I need to cherry-pick certain items.
I'm trying to turn an old Windows machine into a media server and file server, but not sure which Windows apps are Mac compatible. This is sort of hit and miss to post here, as it mainly involves looking for Windows applications, but the mac would be using them so it's sort of suitable.
I have setup a DLNA server for PS3 already which is working correctly. I've setup a UPNP server called Air Video for use with media for the iPhone and iPad.
I tried to setup an FTP server for use with files from both machines but the mac would not connect to it. It kept saying the login was wrong but it was right. I also setup a VNC server which the iphone using iTeleport could connect to but the Mac just would not connect.
So the main question is: Is there a FTP and VNC server for Windows which works 100% with a Mac as the client? After these two are working the server is completed.
I was wondering if there was a quick and easy way of converting a .pages or .doc or .docx to a html page. I cant seem to find anything in pages, although i may have just overlooked it. or if there is another program capable of doing something like that.