| Thread | Last Post | Replies |
|
| major and minor divisions in charts with a y range of >1000. | 31 Jan 2004 23:55 GMT | 1 |
I make depth (y axis) vs time (x) axis on scatter charts. Have good luck until I want to use range greater than 1000. ie: y = 5000' to 6000' ok. Longer than that though, I cannot get the minor divisions to work on the scale. That is: I want my range to be 5000 min to 8800' max ...
|
| Using years as text in a bar chart | 31 Jan 2004 16:54 GMT | 1 |
I have a simple two column sheet with with a series of years (1988-2003) in one column and amounts in the second column. I've formatting the cells in the years column as text. Yet when I attempt to create a bar chart, the chart still treats the years as numbers, i.e, 1988 as if ...
|
| Why can't I link text to autoshapes | 31 Jan 2004 04:09 GMT | 1 |
OK - I've searched this group and found numerous references to this issues: I know - select the autoshape, type = in the formula bar then click on the cell you want to link the autoshape to. Press Enter and voilà the
|
| Data labels??? | 30 Jan 2004 20:27 GMT | 1 |
I have a scatter chart using the following values of the table: GPid mrate cost a 1.5 2.5
|
| Chart With One Series Bars and Two Series of Lines | 30 Jan 2004 19:25 GMT | 1 |
I am trying to create a chart where weekly sales for 04 are represented by bars and sales for 03 and running averages are represented by lines. There seem to be many options for two bars with one line, but not the other way
|
| Labels disappear | 30 Jan 2004 19:21 GMT | 2 |
I have an Excel file that I've set up as a chart template. Each point on the chart is treated as a separate data array so that I can label the point by its name and not its value.
|
| EXCEL VBA - Run-time Error 1004 | 30 Jan 2004 18:56 GMT | 5 |
run-time error 1004 - Copy method of sheets class failed. Sheets("All_Reg_Data").Select Dim i_WHY_AM_I_5 As Integer i_WHY_AM_I_5 = 5
|
| Vehicle Utilisation Chart (Hell Stuck) | 30 Jan 2004 15:48 GMT | 3 |
I need some help, I'm currently reporting on 35+ vehicles and trying to chart quartery utilisation. I have the entire vehicle's utilisation in an excel sheet but I'm trying to get it to generate the utilisation chart so I
|
| Naming a chart object | 30 Jan 2004 14:02 GMT | 2 |
When charts are created they are named "chart 1", "chart 2", and so on I need to name a chart in order to update it from vba, but when select the chart I cannot click in the name box? Help --
|
| excel paste in powerpoint | 30 Jan 2004 13:59 GMT | 5 |
When I paste a chart from Excel to PowerPoint the chart is distorted. For example, the legend is huge and covers up a good portion of the graph. I use the paste special/picture option of pasting.
|
| Multiple Stack Up Chart | 30 Jan 2004 13:55 GMT | 1 |
I have a problem on creating a stack up chart : __A__ __B__ __C__ __D__ 01/02/04 12 23 32 23 02/02/04 32 12 56 56
|
| 3d scatterplot? | 30 Jan 2004 13:55 GMT | 2 |
Is it possible to have Excel do a 3d scatterplot? I need to plot x-y-z data points, and Excel doesn't seem to be able to do that.
|
| Creating a 2 axes custom chart | 30 Jan 2004 13:28 GMT | 2 |
Excel allows you to create a 2 axes chart with side-by- side bars. Is there some way to create a stacked bar chart with 2 axes?
|
| Changing value of "" to be blank | 29 Jan 2004 22:45 GMT | 4 |
When you use cells containing formulas that return empty double quotation marks in the plot range for a chart, the result for the point values of those cells is zero. For example, a line chart shows a continuous line going from
|
| Adjusting Chart source data when column is deleted | 29 Jan 2004 20:31 GMT | 1 |
I have a chart that plots data from $B$9:$BA$9$ on a worksheet in the same workbook. This chart is a running average so every week the first column is deleted and new data is added to BA9. Problem is when column B9 is
|