| Thread | Last Post | Replies |
|
| how do i construct a correlogram in excel? | 16 Mar 2006 23:44 GMT | 3 |
Using Microsaoft Excel 2003, trying to construct a correlogram using data analysis tool pak. Will only accept 255 values .. i have 339. Is there another way to do this, i know it can be done .. but how?
|
| How do I print comments on a chart? | 16 Mar 2006 21:44 GMT | 11 |
Using Excel, I have data numbers added in some cells. In those cells, I have inserted comments. When printing the chart, I want those comments printed next to the plotted data point. Can that be done? If so, how?
|
| Excel Charts with attached comments option | 16 Mar 2006 21:35 GMT | 3 |
It would be good if you could add a comment to a cell and have an option when charting that cell to either show the comment or not. The comment should then be linked to that specific data point. ----------------
|
| How do I set up inches per Minute/Second in Excel | 16 Mar 2006 21:23 GMT | 1 |
I need to know how to take a known inch per Minute and divide by a known measurement and displayed as minutes and seconds. The answer of the equation (minutes and seconds) is where I'm having trouble.
|
| display value axis on both sides | 16 Mar 2006 21:17 GMT | 1 |
I'm trying to display the y axis on both the left and right side of the chart; is this possible, and if so, how to i go about it? thanks.
|
| Axis Data Location | 16 Mar 2006 20:05 GMT | 2 |
I want the data in column 1 to be the Y axis scale and the data in columns 2 & 3 to show as a trend line in the chart. I have played with this 10 ways to Sunday and can't find how to do this. How do I identify the Row 1 to contain column headings. When I import it
|
| date in scatter chart excel 2003 | 16 Mar 2006 17:21 GMT | 1 |
Hey all, I'm having problems with dates in scatter charts in excel 2003. Al dates appear in the year 1900. When I choose any other chart type this works fine, but I definitly need to use scatter chart. When
|
| data labels change format | 16 Mar 2006 17:17 GMT | 1 |
I have an Excel chart with data labels at the top of each series bar. The label is foramtted in Arial font 10point and bold. When I update the data and and refresh the chart, the data lables change to Times new Roman and 12 pt font. Is there a way to lock in the font format as ...
|
| Creating a chart | 16 Mar 2006 13:50 GMT | 1 |
I have a table with 2 columns and 20 lines. This table consists of product codes and there prices. The first column is product code and the 2nd prices. The first 10 items in the list are of the leather range and the 2nd 10 are
|
| vlookup & combo box charts | 16 Mar 2006 10:28 GMT | 1 |
Hi. My question may be difficult to explain, but here i go. I have a large set of data which I analyze each week. I have created a vlookup function to query weeknum & year which presents my data in a nice table format. I then created a combo box with a "list" of all the colum ...
|
| Chart Data Table | 16 Mar 2006 10:19 GMT | 1 |
This is what I want to do, if it is possible. I want to show the data table on the bottom of the chart, but I don't want it to show all the data plotted in the chart. Is it possible to remove some information from the data table, but it still be on the chart?
|
| Combine data rows in Pie Chart | 16 Mar 2006 10:15 GMT | 1 |
I have a large excel spreadsheet that has client names and transaction amounts on it (along with other data). I made a chart that has the names and amount percentages on it, but there is a problem. It lists every transaction from a client as a different piece of the pie. So if
|
| Hiding Columns with Zero Data | 16 Mar 2006 10:14 GMT | 1 |
Is is possible when creating a chart to ignore columns that have no data in them. Such as a Data Table with 31 Days but not all days have data against them. Ta
|
| Plot Highs and lows? | 16 Mar 2006 10:11 GMT | 1 |
I have a chart that pulls in data and updates periodically. Is there anyway to chart I high and a low value for that day? Would this invlove creating two other series of data?
|
| Pie Chart to Percentage | 16 Mar 2006 04:56 GMT | 2 |
I've created a pie chart whose "slices" are automatically re-sized when I type a percentage into a cell. Now I'd like to be able to reverse the process. That is, I'd like to be able to re-size the pie-slice, using my mouse cursor, and have that change the number in the percentage ...
|