| Thread | Last Post | Replies |
|
| Excel 2007 Trendline Equations Incorrect | 12 May 2008 05:10 GMT | 4 |
I am using an XY scatter plot. I have applied a polynominal trendline to the data. The trendline appears to be visually correct. However, the displayed equation does not match the plotted trendline! Sometimes it is obvious, the order isn't even correct. Other times the
|
| Horizontally Banded Chart Background. - on Stock charts | 12 May 2008 00:54 GMT | - |
I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock type chart with 3 data points. I want to use a Horizontally Banded Background to indicate the desired range.
|
| can i water mark part of a worksheet | 11 May 2008 21:18 GMT | 1 |
can i water mark part of a worksheet
|
| Resizing chart data table | 11 May 2008 19:42 GMT | - |
Hello, I have a bar graph with the data table displayed. However, some of my labels are quite long, and they are being truncated. I can't seem to find any way to resize the data table to allow more room for the text. Is there a way to do this?
|
| Trendline Textbox Not Updating | 11 May 2008 16:09 GMT | 3 |
After entering monthly data, the trendline (2nd order polynomial) updates, but the textbox on the chart holding the equation and R-squared values does not. What is the problem? Thanks, Phil
|
| Using less than and greater than in charts | 11 May 2008 11:56 GMT | 1 |
Hi, I would like to be able to create a chart with data which has a less than, greater than format (i.e. >10%<20%) as I don't have the actual percentages. I need the chart to be clustered as I want to be able to plot monthly directions (N, S, E, W).
|
| Bubble Chart - Edit Color in plot area | 10 May 2008 18:29 GMT | 2 |
I wish to edit the color within the plot area from point A but they only allow me to select the whole area and change. Below is an example. I wish to color the area R in red. How to do about it? I do have bubbles around the plot area but don't need to make any change to
|
| Justifying 2-line category names in bar charts | 10 May 2008 18:16 GMT | 2 |
When a category name wraps on to 2 lines, Excel centers the second line under the first. I'd like to figure out a way to right justify the second line. I'd also like to figure out a way to set that as a default.
|
| chart disappears | 10 May 2008 14:56 GMT | 5 |
In excel 2007 I have data on a sheet from which I created a chart. I then moved the chart to its own sheet. I updated the data once a day for a couple days and the chart was also updated. Then one day I open the file and the chart is gone. The sheet it was on is still there. ...
|
| Chart accessibility in a shared workbook | 10 May 2008 13:38 GMT | 2 |
Hi, I have a workbook that contains two charts. There is no protection on the workbook or the sheet that contains the charts. The workbook is shared to permit people to update it simultaneously.
|
| Deleting a chart | 10 May 2008 09:53 GMT | 1 |
I am just starting to work w/ charts. I know that this must seem like an incredibly elementary question - how do you delete an entire chart from a worksheet?
|
| why is freeze panes not enabled? | 10 May 2008 03:48 GMT | - |
I am trying to freeze the panes on a spread sheet, but the freeze panes button is not enabled. What do I have to do to enable it?
|
| Pivot charts filter field in 2007 | 09 May 2008 23:18 GMT | 3 |
I remember in Excel 2003 when you created a Pivot Charts you could drag and drop the fields to the various areas such as Page area, Series and so on. In 2007 I know that I can easily drag and drop the fields in the Pivot Tabel filed list.
|
| change font of all data labels at once | 09 May 2008 22:02 GMT | 1 |
I have excel 2003. How do you change the font/font size of all the labels at one time? I can click on each one and do them one at a time but surely there's a way to do them all at once? :) Thanks
|
| creating a count of dates by quarter | 09 May 2008 18:16 GMT | - |
I am having difficulty building a line chart that shows two lines. One line represents that number of people enrolled into the program during that quarter. The other line represents the number of people disenrolled in the program during the quarter. Below a sample of the table I ...
|