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 RepliesIs there a menu on iWork that allows "extrapolation" on a trend line in a chart or a series of data?
View 2 Replies View RelatedI am currently getting to grips with applescript. I have created some documents using pages 09 and pull in a couple of charts onto these doc's using Numbers 09. I am trying to find the applescipt command that tells Page 09 to Refresh or Sync the data from Numbers 09. you can do it manually by cliekc ing the Sync/Refrresh arrow thingies but i cant find a way to automoate it
Info:
Applescript, Mac OS X (10.7.3)
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 RelatedGot 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.
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 RelatedI 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)
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 RelatedI 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.
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 RelatedI 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 RelatedAnyone 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 RelatedI want to create a Gantt chart using a project management tool such as Microsoft Office Project Professional.
View 5 Replies View RelatedCan 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 RelatedIts benchmark figures for the 2009 imac versus the 2008 imac.
I found it very interesting and answered some of the questions that have been posted on this forum over the past few weeks
[URL]
My iMac system disk has 999.35Gb of storage and shows 511Mb available. However the used figure is 998.83Gb and the system is behaving as if the drive is full and says i'm low on storage. I have an "empty" attached disk also reporting a similar thing.Â
View 2 Replies View RelatedI received an unpublished article in pdf format. On my MBP running 10.5.5, the tables, captions and figures looked fuzzy (out of focus) when I viewed the document using Preview. The main text looked fine. However, they all looked clear when I viewed the document using Acrobat Reader.
View 4 Replies View RelatedMy computer is a G5 but the first generation with a 1.8 GHZ processor. It currently has Tiger 10.4 installed but does have many extra programs Word, Excel,power point etc. If I install Leopard 10.5 will these other programs remain on my computer or will Leopard over ride them? Because I purchased this unit used off of Ebay I do not have any of the discs that would re-install the above mentioned programs. Then again I seldom if ever use any of the programs and wonder if Leopard would be more advantageous or should I leave well enough alone?
View 1 Replies View RelatedHow do I override Spaces? I love my spaces but hate being brought back to a Space when a task finishes in a space that I'm not in. Is there a way to override this?
View 7 Replies View RelatedHow can I disengage my laptop camera...so that I can use another external video camera for a webinar?
Info:
Mac Pro, Mac OS X (10.6.4)
I am currently on OS X Version 10.9.4 with a mac book pro early 2011. I am trying to use my internal microphone because it is a better microphone then the one on my apple ear buds. I just cant find a way to override it to allow me to use the internal one. Every time i plug it in it switches to the external and I either cant use the microphone or have to unplug the earbuds.
Info:
MacBook Pro, OS X Mavericks (10.9.4), Early 2011
I looked all over the system preferences pane, and although I can change the setting for the screen itself, I cannot over-ride the light sensor controlling when I can use the backlit keyboard.
There are some cases where I want the backlighting on, but when I press the button to turn it on it won't let me because the sensor is picking up too much ambient lighting.
I have a EMac with Mac OS X vs 10.3.9 Prior user erased hard drive. Took to ADR data recovery and they scanned the hard drive and were unable to recover any data. Looking for input on other techniques to recover data from hard drive or other companies that specialize in Mac data recovery.
View 6 Replies View RelatedI have a g-drive slim but can't remember the password because I haven't used it in a long time. Checked g-drive website URL...Also checked Apple Support for Time Machine and nothing on how to reset/override.
Info:
OS X Mavericks (10.9.4)
I have read some complaints about what happens with some big excel benchmark or something but try this one on for size: Making a chart with 6 data points took 1 full minute to make and scrolling down after the thing was rendered, damn near impossible! seriously, Office 97 on a 486 beat this! with the right IO,, a FREE CELL PHNE could beat this! I have a brand new Macbook, smoking fast... Can we sue MS for a defective product?
View 9 Replies View RelatedIs there a utility on my MacBook Pro running Tiger which I can call up which shows which applications are taking up HDD space?
View 5 Replies View RelatedI've got 3 large external hard-drives--WD, Seagate, iOmega--connected to my iMac to contain a sprawling music collection. I'm working on deduping, etc., but each attempt to search a single hard drive results in my search being shunted to "All My Files." I'll watch the Finder each time I enter a search term in the window of one drive, and upon entering a syllable in a drive's Search box, the area is expanded to include every folder in at least 4 different hard drives (inclding my iMac's).
I'm not sure if the problem is overly large drives (500 GB to 1.5 TB) or some default setting, probably associated with Spotlight, that interprets each and every search as, basically, "everything Spotlight can conceivably see." Needless to say, my cleaning project is going slow--primarily because I can't work "one room at a time."
Info:iMac, Mac OS X (10.7.2), 2.5 GHz Intel Core i5s).
I
Does anybody know of a flow chart software running on OS X? I would like to convert more portions of my business to the Macintosh.
View 1 Replies View RelatedDoes 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 RelatedI am using MS office for mac and I can't figure out how to insert a text box into a chart for Excel.
View 1 Replies View Related