| Thread | Last Post | Replies |
|
| How do I eliminate non-used dates (weekends) from a chart? | 10 Mar 2005 06:22 GMT | 3 |
My data uses only week day dates. The chart that results from it is adding weekend dates even though they don't appear in the range for the X axis. It leaves gaps in the chart as a result.
|
| Excel - Rendering ASCII via ASP/JScript | 10 Mar 2005 06:19 GMT | 1 |
The project I'm working on currently uses a ASP/JScript combination to popuate a CSV file. The file is then parsed into excel. I've written a function that handles some of the whitespace characters (via regular expressions) that mess up how the data is displayed in the cells. ...
|
| creating drop down lists | 09 Mar 2005 23:49 GMT | 2 |
I need to create a drop down list for a new program to figure out prices. I have looked thru the help section with little resolution. If anyone knows a good web page or can get me started I would greatly appreciate it
|
| Pivot Table "Filtering" | 09 Mar 2005 21:05 GMT | 1 |
Here's my problem: In XL2000, I am using a pivot table to combine two large data sources. What I want to do is use the smaller list in one database as the main reference. However, every time I combine the two tables, I get a list that features the
|
| How do I make a nomogram in Excel? | 09 Mar 2005 00:38 GMT | 1 |
I wanna make a nomogram in excel, can sombebody help me??
|
| Column & Line Charts | 08 Mar 2005 23:12 GMT | 1 |
How do I change a chart data line into a column? When I select the Column & Line Chart option I get half Columns and the other half Lines. I want to control which data series is shown as a column and which data series is shown as a line.
|
| Linking Charts | 08 Mar 2005 13:00 GMT | 1 |
Can I place a link to a different chart inside a chart?
|
| How do I make a 3 d graph using depth in Ft., a N-S direction in . | 07 Mar 2005 19:33 GMT | 1 |
I am trying to make an oilwell borehole 3 d graph. The data I have available is the depth in feet, the direction in a North/South Direction and from an East/West direction, both in feet, from a GPS references starting point. I would like to track this well bore and compare it ...
|
| I'm trying to get a custom graph in Excel | 07 Mar 2005 19:30 GMT | 1 |
I'm trying to graph the sales development of one sales territory when compared to the overall sales development of the corporation; the Y-axis values should be in percentage, the X-value axis is in years 1995 through 2004. I like to have it graphed similar to a stock graph, ...
|
| How do I create a boxplot using StatPlus with an unequal number o. | 07 Mar 2005 14:33 GMT | 4 |
I've got the StatPlus add-in for Excel and have data sets with unequal number of data points. For those columns that have fewer data points, the cells are blank. I am trying to create a box plot using this data, but unless all of the columns have the exact same number of data ...
|
| Creating a line graph from 2 pivot tables? | 07 Mar 2005 14:09 GMT | 3 |
I have two pivot tables, one contains information RECEIVED in a week for a country and the other contains information ACTIVATED in a week for a country. The countries and time range are the same for both. Within the line graph I would like to show, how many things were RECEIVED
|
| Alternatives for Excel for charting dated time-series? | 07 Mar 2005 13:21 GMT | 2 |
I need to chart dated time-series using simple line charts. I recently got a trial of a financial data service, CEIC. It is a breeze. I click on a dated time series, and, hurrah! A graph pops up. I click on the next, and yahoo! Another graph. It makes life
|
| Chart data range | 07 Mar 2005 13:17 GMT | 2 |
Is it possible for a pie chart not to chart where there is a zero in the data without altering the data range?
|
| No void value skipped by graphic chart | 06 Mar 2005 16:27 GMT | 3 |
I use Excel 2000. If the cell contet is "" and it is e result of a formula like IF(True;"";1) the "" value is used like e zero in all type of graphics. Why the graphic doesn't skip "" value????
|
| linking/updating two files for charting | 06 Mar 2005 01:59 GMT | 1 |
I have two files, one with data that is for, say, A, B, C, D periods. I have another file which has a chart which refers to file 1, and only takes data points A-C. I regularly have to go into the chart file and update the
|