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.
View 3 Replies
ADVERTISEMENT
Nov 18, 2009
I can't seem to figure out how to create a chart based on the following info: I have 3 columns: Date, Time & Value Looks like this:
Date Time Value
10/1/09 12:00am 35.5
10/1/09 01:00am 33.4
10/1/09 02:00am 17.5
.
.
10/2/09 12:00am 27.4
10/2/09 01:00am 44.5
10/2/09 02:00am 3.5
.
.
10/31/09 12:00am 56.5
10/31/09 01:00am 15.7
10/31/09 02:00am 10.4
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.
View 1 Replies
View Related
Feb 7, 2010
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.
View 1 Replies
View Related
Oct 5, 2009
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.
View 2 Replies
View Related
May 3, 2010
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.
View 4 Replies
View Related
Jan 30, 2009
I want to create a smart playlist in Itunes like this:
-NOT contain recently listen ARTISTS (1 day)
So if Itunes plays and ARTIST then the Smart Playlist will refresh and extract all Songs with that artist.
Is it possible?
View 2 Replies
View Related
Jun 25, 2014
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.
View 1 Replies
View Related
Mar 12, 2010
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?
View 2 Replies
View Related
May 8, 2012
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?
Info:MacBookPro
View 6 Replies
View Related
Sep 21, 2010
I need to create a histogram for school. How do you create one in Numbers '09?
View 2 Replies
View Related
Jul 17, 2010
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"
View 1 Replies
View Related
Mar 24, 2009
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.
View 3 Replies
View Related
Feb 20, 2012
How do I create running page numbers in Pages? I need to write a paper using APA format.
Info:iPhone 3G, iOS 4.3.3
View 4 Replies
View Related
Apr 20, 2010
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.
View 1 Replies
View Related
Dec 7, 2010
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?
View 3 Replies
View Related
May 24, 2010
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).
View 2 Replies
View Related
Jun 19, 2012
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.
Info:
MacBook Air, Mac OS X (10.7.4)
View 1 Replies
View Related
Oct 22, 2010
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.
View 6 Replies
View Related
Apr 11, 2010
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).
View 1 Replies
View Related
Apr 10, 2006
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.
View 2 Replies
View Related
Oct 19, 2009
I want to create a Gantt chart using a project management tool such as Microsoft Office Project Professional.
View 5 Replies
View Related
May 22, 2012
how to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
View 3 Replies
View Related
Mar 20, 2009
Is there a menu on iWork that allows "extrapolation" on a trend line in a chart or a series of data?
View 2 Replies
View Related
Nov 14, 2009
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.
View 2 Replies
View Related
Jul 28, 2008
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.
View 24 Replies
View Related
Aug 10, 2010
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.
View 1 Replies
View Related
Feb 15, 2012
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.
Info:PowerMac, Mac OS X (10.4.11), 4 GB Ram
View 4 Replies
View Related
Dec 9, 2010
How can I run it without WM Ware Fusion or Parallels? Is there an app where I can run it somehow without such programs?
View 1 Replies
View Related
Dec 26, 2010
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.
View 11 Replies
View Related
Apr 10, 2009
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.
View 2 Replies
View Related
