| Thread | Last Post | Replies |
|
| Time chart | 24 May 2004 03:50 GMT | 3 |
I need a time chart as in example A1= Henry B1=15 C1=21 A2= Sally B2=12 C2-=18 A3= George B3=11 C3=16
|
| Treatment of blank cells in chart driven by a combo box | 24 May 2004 03:48 GMT | 4 |
On this messageboard, I was provided with an effective solution to convert non-numerical cells to blank cells (using the ISNUMBER function) so that the text cells would not be plotted as zero values.
|
| Formatting of chart elements | 23 May 2004 07:16 GMT | 5 |
Is there a way of changing the font of one only of a number of a) category labels; an b) data labels for a series?
|
| This chart might be tough | 22 May 2004 23:14 GMT | 3 |
I'm trying to create a chart known as a "Stiff" diagram that plots chemical ionic concentrations on the X-axis with the cations in the left Y axis and anions in the right Y axis. The ionic concentrations should be scaled
|
| Break links turn last number in bubble size to zero | 22 May 2004 22:53 GMT | 1 |
I have a master file with bubble charts. In a loop, the 2 sheets with the charts and the chart data get copied to a new workbook, saved with another name and links to the master file are broken. When this happens, the last number on my bubble size gets turned into a zero.
|
| Using a Fomula to Select Chart Values | 22 May 2004 22:51 GMT | 4 |
We want to set the values for a chart series by using a formula. We want to set the series equal to a range in a worksheet less the values in a second range. In the series "Values:" box of the source data dialog box
|
| Automating changes in order of columns and/or stacks | 22 May 2004 09:00 GMT | 14 |
After much time by me and assistance by people in this newsgroup, I am almost finished what I confidently expect to be the only chart I'll ever produce in my lifetime. Only one matter remains to be done, if possible. The chart displays six simple columns and three stacked ones. I've ...
|
| Scaling XY charts with suppressed starting value | 22 May 2004 04:33 GMT | 4 |
The autoscaling feature of the Excel graphing function seems to have (limited) mind of its own. I'm trying to graph Y-values in the -1.5 t 1.5 range and X-values from 190 to 410 with the minimum from 190 to 29 and the max value from 290 to 410.
|
| dashed line and marker frequency | 22 May 2004 03:10 GMT | 1 |
I posted this kind of topic about 6 months ago, and I didn't get an answer. I just wonder whether there are some new add-ins that make dashed line looks dashed line and customize the frequency of markers in a chart for large amount of data. I have seven curves in a chart and I need ...
|
| Plot background | 22 May 2004 02:48 GMT | 1 |
I want to use a picture as the backround for a chart, but I do not want it "stretched." When I click on fill effects and select the picture, it defaults to stretch and my other options (Stack and Stack/Scale) are greyed out.
|
| Scatter Charts | 22 May 2004 02:42 GMT | 7 |
I am plotting a XY chart. I want that every point should be of different colour. Possibly I can define a range of 2 columns where column 1 contains the name for which the point is plotted and column 2 contains the colour for that point. I have seen this being done in one chart but ...
|
| adding a chart | 22 May 2004 02:41 GMT | 5 |
hey i have to write a short VBA script for a school project and i am tryin to add some charts into my worksheet without success. i am dealing with an Excel object (which i call App) and i managed t
|
| REMOVING GAPS IN DATES | 22 May 2004 02:40 GMT | 7 |
I want to chart some production data. Right now I have a x-y scatter and it plots the dates on x-axis and the data on the y-axis. The boss would like the dates that we did not run production to be cut out of the chart.
|
| auto import date/time from .txt file | 21 May 2004 23:02 GMT | 1 |
is it possible for excel to automatically import date/time info from a .txt file in the following format: "LASAIR110","04/05/19","15:47:41",2700.0,45.00,"V6.3",0,0,0 ,1,433,486,236,113,294,196,103,328,4.993,1.0000,0.000,0.000
|
| Trendlines in Pivot Charts | 21 May 2004 14:47 GMT | 6 |
How do I add a trendline to a chart based on a pivot table? Is it possible Thanks
|