| Thread | Last Post | Replies |
|
| Gaps in Line Chart | 11 Dec 2006 19:57 GMT | 4 |
I have a line chart wherein my data for the line is in A1:A100... and my data for the date is B1:B100 NO PROBLEM Every 15 days, i.e. in rows A15:A17, B15:B17
|
| How can I subtract and enter times in my charts? | 11 Dec 2006 03:10 GMT | 4 |
I am charting times and have various entries such as 46 seconds and 4 fifths or 1 minute and 12 seconds and 2 fifths (such as the 1/2 mile time and winning time in a 6 furlong horse race). I need to display and subtract these times properly. The race results in the newspaper ...
|
| what do you use a doughnut chart for | 10 Dec 2006 14:30 GMT | 5 |
I just want to know what they are for
 Signature QuietRanger
|
| Error Bars | 10 Dec 2006 09:51 GMT | 1 |
I have error bars in a graph I have set up. Does anyone know how I can have the vertical error line extend from the top-edge down to the bottom-edge of the graph without altering the automated Y-axis scale? The error bar is working, but the vertical line is pretty short and I ...
|
| population pyramids using bar charts with a secondary axis | 10 Dec 2006 09:41 GMT | 10 |
I have a problem that I had given up as unsolvable, but after recently learning about secondary axes, I've made encouraging progress. However, I'm stuck on the last step(s), and I'm hoping that someone will have some suggestions.
|
| Automatic repositioning data labels subset when chart updates | 09 Dec 2006 04:17 GMT | 3 |
Several Excel charts. 25-month period. Each month a data point. Only 1st, middle and last data points labeled. As data is updated each month, the data labels do not shift up/down with the new first, middle, last data points. Manual repositioning is time consuming.
|
| Error in chart parentheses display | 08 Dec 2006 15:12 GMT | 3 |
I've run across an odd error in Excel 2003. If I have an axis title or chart legend that ends with a right parentheses (e.g., "Units (000)" ), then the right paren ends up before the first character in the text string (i.e., ")Units (000" ). I can find no other mention of this
|
| How do you link chart source data when you copy the chart? | 08 Dec 2006 02:40 GMT | 1 |
I have rows and columns with data. I then chart the data which links the source data to the specific cells with absolute references. If I try and copy the rows et al with data and the chart and paste another group of the same below it, the rows et al of data change the cell ...
|
| "leader" lines from X axis to label | 07 Dec 2006 18:27 GMT | 2 |
Is there any way to get the tick mark on the X axis to extend down to where I've offset my X axis labels? Another thought is vertical gridlines, but I don't want them to stretch into the plot area. Any ideas?
|
| I made a chart on worksheet because not built in | 07 Dec 2006 16:06 GMT | 1 |
I need feedback on it, but don't want to post file. This is the greatest thing since sliced bread, or at least I think it is.
|
| Chart axes color index vs font color index | 07 Dec 2006 16:05 GMT | 4 |
quick question here regarding color indexes. Our company approved Powerpoint style has a dark background, so when we paste Excel charts we need to change all the black elements to white. I thought it would be faster to just change black to white in the "tools .. options..
|
| Colour gradients in charts | 06 Dec 2006 20:35 GMT | 2 |
Is it possible to create a colour gradient between two linear boundaries parallel to X axis, in any of these ways? A single colour ranging from light to dark or three colours blending from green through amber to red. Have tried inserting a filled rectangle and also importing an ...
|
| How to extract the address of a chart serie | 06 Dec 2006 17:24 GMT | 1 |
I would like to extract, within a vba procedure, the range a chart serie comes from. I know about the following code: myvar = ActiveChart.SeriesCollection.Item(1).Formula
|
| Unable to set the XValues property of the Series class | 06 Dec 2006 03:34 GMT | 1 |
I'm using a xlXYScatter chart with 3 series. When I try to assign the Xarray with 200 values to the XValues like this: objChart.SeriesCollection(1).XValues = Xarray I got the following error:
|
| text data on X axis | 05 Dec 2006 18:46 GMT | 1 |
Is it possible? My Y data are numbers but I would like to put the X coordinates as text, eg.: (a;12), (b;9), (w;2;8) etc., the chart of XY type. I can't find anything like that in Help. Thank you.
|