Applications :: Excel 08 - How To Display Null Values In Chart
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
ADVERTISEMENT
Sep 12, 2014
The TRUE/FALSE value are not displayed when opened on MAC OS X 10.4.
Info:
Mac mini, Mac OS X (10.4)
View 9 Replies
View Related
Mar 20, 2009
I'm trying to create a chart on excel 08 that for the following type of data:
A X Y
1 a 4
1 b 5
1 c 8
2 d 4
2 e 7
2 f 6
3 g 4
3 h 7
3 i 2
The graph has column X on the X-axis and Y on the y-axis. Is there a way graph the means of the Y column for each of the groups in column A (1's, 2's, 3's)?
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
Mar 2, 2008
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 Related
Feb 4, 2012
I 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
Feb 20, 2008
I'm doing a paper in Office 2008, and need some charts for better visualization. I want to have some graphs showing the numbers of listeners of ten different radio stations by columns.
To provide good labeling I thought about the names of the radio stations under the chart, but horizontally it's quite a mess, vertically is hard to read. So is it possible to orientate the labels diagonally, maybe sixty degrees or see instead of the pre formatted settings of 270 degrees? I couldn't find definite answers via Excel help or even Google. ("excel chart labels orientation").
View 1 Replies
View Related
Jul 9, 2009
I was reading that the new 13" Macbook Pro display can display 60% more of the color gamut. See http://www.apple.com/macbookpro/features.html. That page includes a chart showing the color gamut, and a triangular portion of it that the laptop can display. So I started thinking, if a display can only display a portion of the color gamut, then how is it able to display a chart which includes the whole color gamut?
View 3 Replies
View Related
Dec 29, 2009
My rows in Excel display in Numbers (1, 2, 3) instead of Alphabetical (A, B, C). Therefore I cannot type formulas for fields using A1, B2, C3, etc.
View 2 Replies
View Related
May 6, 2009
when listening to the radio the station name shows up with "(null)." in front.
View 2 Replies
View Related
Feb 6, 2009
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
View 6 Replies
View Related
Apr 13, 2010
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
View 1 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
Oct 21, 2010
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
View 3 Replies
View Related
Oct 21, 2010
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
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
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
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
May 22, 2010
I recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
View 4 Replies
View Related
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
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
Nov 10, 2009
When I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
View 2 Replies
View Related
Mar 5, 2012
I regularly export and save my Safari bookmarks in case I'm ever stuck having to use a different computer.
Now I've just thought - I have several forums where I never have to remember username and password as Safari remembers them for me. It would be very useful to export and back those up too. But, where are they held? My guess is ~/Library/Safari/Form Values. However, when I tried to confirm this by opening in TextEdit, it was in the form of unreadable symbols. Nevertheless, is that the file I need to backup?
Info:
PowerBook, Mac OS X (10.5.8), G4, 1.67GHz, 1GB RAM, 250GB HD
View 1 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
Jan 2, 2011
Whenever I try and open up my energy saver preferences a pop up appears "Could not install (null) preferences pane". The energy saver preferences is not in my system preferences anymore I have to spotlight search to try and open it. I have the highest update on all of my settings for my macbook pro (one of the original 13" pros from when they changed the macbook unibody to the macbook pro). I've tried googling and nothing really substantial comes up or I just cannot understand it. I've tried repairing disk permissions etc.
View 3 Replies
View Related
Apr 18, 2012
When I run the mdls command on a ringtone file to fetch its duration, the output is always null. For e.g running
mdls -raw -name kMDItemDurationSeconds SomeTone.m4r on the terminal returns (null) as the output. When I check the info for the ringtone in iTunes, I see that it's 14s long. Same issue when I try to fetch the total bitrate for the ringtone using mdls. It also returns null. Why does mdls fail ?
Info:
Mac Pro, Mac OS X (10.7.3)
View 2 Replies
View Related
