I have been trying to plot a simple line graph in excel 2008, using two columns, one with my x values and one with my corresponding Y values. However I cannot do it..it will not let me put the data together but rather has two separate lines for each column...or it will have all points in a straight vertical line...i am really confused on why it is so difficult to make a simple graph
View 1 Repliescannot find the solution. Im currently working on a simple graph, i.e. year vs population (bar or pie). I would like to show the actual value as labels of the bars/pies..I know this is very simple in windows but I dont know in mac yet.
View 3 Replies View RelatedI need to make a very, very simple line graph. In column A, I have a list of years. In column B, I have the data....numbers that correspond to something in that year. Simple, right? It really couldn't be any less complex. I selected both columns, then I went to create a new line graph, and it created a graph that had the years (from 0-2500 even though the actual range is 1973-2005) on the Y axis, and the data on the X axis. And each column of data was its own series, so I had 2 lines, which, due to the scales, was basically 2 horizontal lines. I removed the extra series (the year series), and was able to get the line to look right. It also put the column B data on the Y axis like I want, but on the X axis, it just counts from 1-33. But I want the years on the X axis. How the hell do I do this? I'm 99% positive Excel 2004 let you set the X axis labels.....did they really remove it in 2008? This seems like something that should be so simple, I shouldn't have to post on a forum to figure out
View 24 Replies View RelatedI am trying to paste link a graph from excel into powerpoint. The paste link option is not available. I also tried to paste link the data from the spreadsheet part of excel to the graph slide type in powerpoint so it can create the graph. The spreadsheet in excel is formula driven so it pastes with ref errors.
View 2 Replies View RelatedDoes anyone know if you can label axis in excel 2008? I know before SP1 it couldnt be done, just wondering if anyone has come across this in the to SP1? Or it can be done already? Because its pretty useless for me without that feature!
View 4 Replies View Relatedim just wondering is it possible to plot a log graph in the grapher software with a given set of data, and also give an error bar and a best-fit line for it?
so here is the set of data, Concentration of BCh (M)Mean % Specific Binding (%)Standard Deviation 3 ×10⁻⁹71.529.521 ×10⁻⁸57.308.563 ×10⁻⁸39.159.401 ×10⁻⁷24.1310.153 ×10⁻⁷14.773.311 ×10⁻⁶7.222.02
In Pages, I need to put a line graph into a document, but I can't get it to look the way I want. Is it possible to put the labels on the y-axis, with the numbers along the x-axis? I have all the data in the graph, but it's just not oriented correctly; and the orientation in important for the class this document is for.
View 4 Replies View RelatedI'm currently trying to create some graphs in Excel, and the data isn't plotting as I would like it to be - not sure if there is something I am doing wrong here or if there is a setting to change. My data goes like this:
Mass (g)Average Period (s)
502.074
752.089
1002.110
1252.111
and I would like mass on the x-axis and average period on the y-axis. However, my graph is placing both values on the y-axis and placing a key beside the graph. The graph and the way I have set out the data are attached below.
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)?
I accidentally trashed two of my icons on my icon bar I didn't put them in the trash but when I clicked them they turned into wads of trash. I don't know how to find them now?
Info:
MacBook, Mac OS X (10.5.8)
There are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it? I've tried looking and have come up with nothing so far.
View 12 Replies View RelatedI 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 RelatedOperating System: Mac OS X 10.6.3 (Build 10D2094) CPU: Intel Core Duo, Number: 4, Speed: 2147 MHz
Haven't had a problem to date and after opening a file that excel obviously struggled with for some reason, excel open briefly then I encounter the following error message. Much obliged for any help or guidance.
Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2010-09-27 21:45:42 -0400
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.2.6.100708
Crashed Module Name: libobjc.A.dylib...............
I'm having a problem where whenever I change a particular cell in a relatively complex spreadsheet I built, Excel crashes. The cell is a trigger cell that changes a list of assumptions to calculate a particular scenario. The spreadsheet was working fine and then, all of sudden, this problem arose. I had this same problem about 3 weeks ago and ended up copying individual tabs into a new spreadsheet and globally replacing the links so it was working. That worked okay until this most recent incident. The stranger thing is it seems I can open the spreadsheet using Excel for Windows and it doesn't crash.
View 8 Replies View RelatedHow do you get rid of dollar signs in Excel 2008. I see the $ symbol, but that only adds them. If I click it again, it doesn't remove them.
View 1 Replies View RelatedOne of my favorite functions doesn't work - really weird. When I get to line 50 of the workbook it stops working! It doesn't matter if I cut n paste, drag or manually input the formulae it just stops ! Every row above row 50 - it works - below 50 ... nope #value appears. So an argument is wrong - but I'm inserting the same argument that works above !!!!
Is this an Mac Office glitch or am I losing my mind
Any advice appreciated . . . Stu
edit: just realised that if I increase the lookup to row 75 the reference works up to row 75 but not beyond - weird. I can't replicate the problem on MS Office on a pc !
I have been trying to insert a simple monthly calendar into an excel spreadsheet, but cant find a way to do this on the mac version that im running. Any hints would be great. Idealy i would like to be able to just insert a calendar for that month but if i had to insert the whole calendar each time that would be fine too
View 2 Replies View RelatedSome content in Name.xls may not be saved because it is not compatible with the Excel 97-2004 Workbook (.xls) file format. Do you still want to save the workbook in this format? To save the workbook in a new format and preserve all content, click No, and then on the Format pop-up menu, click Excel Workbook (.xlsx). To save the workbook in the current format and remove all incompatible content, click Yes." Somehow I managed to not read the popup properly and just went ahead and saved (clicked "yes"). I then closed the spreadsheet and now all the work from the past 4 hours is gone.
View 2 Replies View RelatedI know Excel 2008 does not support VB macros, but did anyone notice that "Macros..." is still available under the Tools menu? I wonder why it's there? BTW, I saved an old file in Excel 2008 that had macros and then opened it in Excel 2004 to see if the macros are still there. They are. That's a big relief, because I know I can at least work on files that have VB code in them without worrying that if I save the file in Excel 2008 format the macros will go poof. Ooof
View 8 Replies View RelatedIs anyone else getting this problem? When I hit Command+S in a worksheet, Excel unexpectedly quits. Very frustrating as backing up is kind of a problem.
View 3 Replies View RelatedI have a very limited knowledge of Excel, but generally find that I can figure things out eventually. However, this time, I just can't seem to tweek it so the result is what I want.
I have a spreadsheet for tracking parts ordered, and simply need to display how many days a part has been on order. I have a column for date ordered, and one for date received. Is there a way to program the formula to tell me the days that a part has been on order without displaying today's date in the spreadsheet (leaving it blank), and still be able to enter the date that it does arrive for our records?
New to Mac and new to Office 2008. When i try to save an excel file once I click the little upside down triangle to choose where the file should save to the dialogue box which opens is larger than the screen with the save box to the right of the screen. How do i resize this so that I can see, and use, the whole dialogue box?
View 9 Replies View RelatedIn my old old old excel 2003 when I was searching for some words in excel sheet (e.g. in the column) I could choose "to find all" option. So I saw all the results in the "find" window. In excel 2008 for Mac I can see search results only one by one not altogether. On microsoft site http://www.microsoft.com/mac/help.ms...f-17820d214cef
I couldn't find tha answer also. Does anyone know how to make it in excel 2008 for mac so i could see all search results in the "find" window?
How do I get data analysis in excel 2008 in mac?
View 3 Replies View RelatedThis might be the weirdest software bug I've ever seen. It looks like maybe a programmer for Microsoft was having some fun. Here is what happens:
A spreadsheet that a coworker uses for purchase order requests has several cells in a column with a SUM field that calculates the number of units to purchase multiplied by the unit price (not sure why they use SUM for just a multiplication, but I don't know if that matters).
If you delete the contents of one of these cells and type in something else (or just type something else without deleting first), then exit the cell, an error message pops up that says, "You can't do that!!!!! So quit trying!!!" with options Cancel and Retry.
Retry doesn't do anything, Cancel clears what you put in the cell. Copying and pasting the cells into a different row creates the same issue.
I've attached several screen shots to show steps to reproduce:
Picture 1 - column F has the suspicious cells
Picture 2 - the calculation
Picture 3 - after deleting the contents
Picture 4 - enter some text, before exiting the cell
Picture 5 - error message after exiting the cell
The only workaround was deleting the entire row and entering those calculations again. I have no idea what to make of this, and internet searches have come up empty.
I am running Excel 2008 on my MacBook Pro. I'd like to conditionally format some cells in a single column with a condition format like: <COndition 1> AND <Condition 2> AND <Condition 3> However, the (paltry) help seems to suggest that I can only do a logical OR of the conditions. It says "If more than one condition is true for a cell, Excel applies only the formatting of the first true condition to that cell."
Although that is a bit vague, I certainly can't get it to do logical AND through the graphical interface. Google has failed to find me the answer. Sniff.
i was using my (late 2008) macbook 2.0Ghz when i noticed a vertical Blue Line going across the screen from the top to the bottom. I have uploaded pictures for you guys to see below.MY APPLECARE HAS ENDED!Can someone explain if this is something wrong with the LCD screen itself or the video card or the connector is loose?And if its a software or hardware problem, how to solve it by software? i have quoted asolution. But can someone verify if it works?
View 11 Replies View RelatedI'm having a problem with line spacing and images in Word 2008.
I've taken a few screenshots to illustrate the problem.
As you can see, the line spacing is awkward. There's no enter between these lines, but for some reason there's a lot of space between them.
Now this is what happens when I nudge the caption of the image on the left upwards.
The spacing is fixed! But now my caption is in front of my picture, which, obviously, isn't what I want..
Anyone have a clue as to how to fix this?
The planned mid-January release of Office 2008 offers a significant overhaul of the productivity suite's look and features.
The previous segment described new features in Word 2008, with some comparisons to Apple's Pages 08. This article examines what's new in Excel 2008 and contrasts Microsoft's oldest application to Apple's newest: the Numbers 08 spreadsheet included with iWork.
Excel opens up a gigantic size blank document anytime I launch it. I gather there is no way to disable it giving me a (useless) blank document. But is there a way to not make the stupid document take up 90% of my screen?
View 17 Replies View Related