Excel basic chart data layout Ive just been upgraded to Office 2007 and trying to get data were I want in a basic chart is surprisingly difficult. I have a table with three columns; Potential Hazards, Severity and Probability I want a column chart with Probability in the X axis, Severity in the Y axis and the corresponding Potential Hazar... 28 Apr 2010 12:54
how do i get 2 words in one cell on top of eachother? Like in word when you hit enter in a chart it expands the cell and allows you to have more than 1 word on top of eachother? ... 28 Apr 2010 09:29
Can I set 2 charts to have the same Y axis? I know I can hardcode the min/max for the Y axis on two charts to match. But I have a case where we have data coming in that can be very different week from week. Is there a way to tell Excel to calculate the min/max for the Y axis on two charts - but to use the combined data from both when calculating so the tw... 27 Apr 2010 23:33
Why would the same chart appear different to two users? I created a chart in 2007 Excel which looks fine. I sent the file to a co-worker and when she opens it the chart has all of the data pushed into the left half of the chart with the right side blank. Chart is using a primary and secondard vertical axis. I can provide screenshots of what I see and what she see... 27 Apr 2010 16:49
Updating source data links Hi all, I'm having a small (major) issue with editing my links from graphs and data when moving the file of the original source. I'm rearranging my drive as it's just turned into a bit of a mess and I'm looking to just start over with new folders etc.. However I'm going to become unstuck when moving some of the... 27 Apr 2010 15:40
How do I draw an accurate venn diagram? I'm trying to draw a venn diagram in Excel, to show where survey respondents have responded 'yes' to two questions. Microsoft Help refers me to the picture toolbar but that only allows me to draw an approximate venn diagram, not to generate one automatically based upon the data I've collected. Any help gratefu... 29 Apr 2010 16:57
2 chart types within a graph I have a chart with three data series. Two of them I want to stack together, and a third to stand on its own. When I select the data series that I want to stack, it stacks all three data ranges, even though I've only selected one data series, not all of them. I can't figure out how to do this. ... 27 Apr 2010 09:55
round robin tournament programming looking for a round robing tournament program for sports 2 or 3 courts 6,8, 10, 12, 14, 16, persons ... 26 Apr 2010 23:58
Creating separate graphs for columns of data Two issues to solve for data that looks like this: Customer Jan Feb March Apr ... A 10 5 4 3 B 6 6 5 2 C 0 9 0 3 D 8 1 0 0 E 5 0 1 0 1st: I wou... 26 Apr 2010 22:52
graph column line graph with two axes I need to make a graph with two axes, one series as a column and two different series as a line graph. When I add a new series, I can get one column and one line, but when I add the third series it turns the second series from a line to a column. How can I add two lines graphs and only one column. ... 26 Apr 2010 16:06 |