| Thread | Last Post | Replies |
|
| How can I create a Gauss chart in Excel | 14 Dec 2007 20:53 GMT | 1 |
Can I produce a Bell (Gauss) curve in Excell?
|
| Vertical error bars only | 14 Dec 2007 19:54 GMT | 2 |
I have several line and scatter graphs where I want to add vertical error bars ONLY. Every time I try to do this, horizontal error bars appear as well. Is there a way of only inputting vertical error bars? I don't want to have to delete the horizontal ones every time as this ...
|
| Secondary Axis Grid lines | 14 Dec 2007 19:52 GMT | 1 |
Is there a way to show grid lines for a secondary y-axis?
|
| Bar graph to line graph | 14 Dec 2007 19:51 GMT | 1 |
I am trying to redo a chart by looking at a scanned image on excell. It's a line graph. The 4th options under standard graphs. But, then I went to Custom Types and the graph I need is the B&W Column but it turns my graph into a bar graph. I need it to stay as a Line graph.
|
| Displaying the mean in a bar chart | 14 Dec 2007 18:41 GMT | 1 |
I have a stacked bar chart showing test score distributions. I would like to be able to plot the mean score on the bar. A simple dot or square would do. Anyone know how to do this? thanks!
|
| Stop moving trendline equations | 14 Dec 2007 00:17 GMT | 3 |
I have a set of charts that have source data that will change often. I have the regression equation displayed on the chart and the user needs to use the equation for the rest of the procedure. Often, when new source data is put in the regression equation will move from
|
| Cluster AND Stacked Bar chart | 13 Dec 2007 23:44 GMT | 1 |
I'm curious whether I can create a combination cluster AND stacked bar chart. I have a group of students I'm tracking out over a number of semesters. As semesters progress, I'd like to indicate the number that engage in a certain beahvior (stacked bars). I'm tracking four ...
|
| Excel 2007 - Dynamic names for chart series | 13 Dec 2007 20:12 GMT | 2 |
The dynamic names I used to utilize in Excel 2003 to define the data range for charts in my worksheets don't work anymore, because excel modifies them upon saving the file : Filename.xls!DynamicNamedRange gets changed to [0]!DynamicNamedRange for all
|
| Is this bug in Excel 2007 charts? | 13 Dec 2007 20:10 GMT | 5 |
This is a problem with "dynamic charts" that occurs in Excel 2007 but not in Excel 2003. Create a SS in Excel 2007 with two worksheets. On the first sheet, enter a column of data (a few rows' worth is enough). On the other sheet, define a single-cell named range "years". Now go ...
|
| Auto update the chart range for new sheets | 13 Dec 2007 18:42 GMT | 2 |
Hey everyone, I've got a workbook with data for multiple locations. There are 2 main worksheets for each location: Sheet #1 is a data entry sheet
|
| Data display | 13 Dec 2007 18:23 GMT | 3 |
I have a set of data, the number of aircrafts sold each month from 1992 till 2007. I want to display them onto a column chart (easy!) but occassionally I want it to show only the data for each quarter, and not all of them. Whats the simplest and easiest way of doing that without ...
|
| inserting specific points on a graph and label them? | 13 Dec 2007 14:15 GMT | 5 |
Hi, i have excel 03 and have creating a xy scatter graph of frequency response and i need to mark 2 specific points on the graph and label them. Does anyone know how to do this?
|
| Excel 2007 Polynomial Order Incorrect | 13 Dec 2007 14:10 GMT | 4 |
We recently upgraded to Office 2007. When we attempt to do a trendline in Excel, the order of polynomials is always one below what it is stated to be and the highest ordered polynomial is always wrong. (i.e. on a fourth order polynomial, it will only display polynomials through ...
|
| Increase plot size within Chart area | 13 Dec 2007 14:07 GMT | 3 |
Help, report due today. How do I increase the size of the plot area to fit more closer to the chart area margins. I would like to bring the plot area closer to the border of the chart area. This has been annoying me. Moving the chart handles to increase the size simply moves ...
|
| Copy a graph within a workbook in Excel 2007 | 13 Dec 2007 13:42 GMT | 6 |
I have an user who is trying to copy a graph and data onto a new worksheet in a workbook. The problem is that the graph points back to the original worksheet and we need it to point to the new one. Does anyone have any ideas on how to accomplish this? I can send a sample workbook ...
|