| Thread | Last Post | Replies |
|
| Hide Progress bar in Chart.Export | 10 Apr 2004 05:04 GMT | 2 |
I have a Excel Workbook which has 2 Worksheets. One work sheet has dat and the 2nd worksheet has a graph based on the data. I have a Macr which connects to the datasource, updates the data in the 1st workshee and further saves the graph on worksheet in to a GIF image in the fil
|
| Timelines | 10 Apr 2004 04:58 GMT | 1 |
I'm trying to do an easy timeline using a chart (bar or line - either) - I don't need any label on the y axis - the x axis I need each month - like Jan 1, Feb 1, Mar 1 etc. Then the bar used to plot milestone activiity dates I have on another sheets. Something like ...
|
| Clustered Column Chart with Second Axis | 10 Apr 2004 04:56 GMT | 2 |
I have a clustered column chart with 5 sets of A-B data, as follows: Code ------------------- Orchard Traditional
|
| waterfall that crosses X-axis | 10 Apr 2004 04:52 GMT | 2 |
does anyone have a waterfall chart that crosses the x-axis? I've read several postings that say, look at this example, but none that just say here :) i'm sure I could play with the idea for a couple days and come up with
|
| drawing objects in a graph | 10 Apr 2004 04:51 GMT | 3 |
I when I add a straight line (from the drawing tool) to a chart, it only appears when I click off the chart. When I select the chart, then it appears. This is a problem because sometimes I need to select the chart to copy it to
|
| Getting Rid of Blanks that Graphs Zeros | 10 Apr 2004 04:49 GMT | 2 |
When I graph a chart from my data subset that includes some blank cells it graphs them as zeros. How can I make it skip the zeros and just insert the blank?? Please help
|
| Plotting a chart on two axis | 10 Apr 2004 04:47 GMT | 2 |
I am trying to plot a line chart on two axis with more than two series. e.g. series 1 = price, series 2 = %, series 3 = %, series 4 = %. Excel decides which series is plotted against which axis, how can I determine this
|
| X axis on histogram | 10 Apr 2004 04:36 GMT | 4 |
I have a series of data between the values of 0-100 and i have plotted the frequency of the numbers using the bin 0,10, 20, 30, 40 etc... 100. The histogram looks like the bars appear in the column above that which they should
|
| Can I have gridlines appear in front of columns? | 10 Apr 2004 04:33 GMT | 4 |
I want the gridlines to appear in front. Is it possible?
|
| X Error Bars appearring when it is not set | 10 Apr 2004 04:26 GMT | 1 |
I am using the ErrorBars in my chart. I only want the Y Error Bars to show on my chart and I set it correctly in my program using .ErrorBar Direction:=xlY but it appears as a bug in Microsoft Excel Macro.
|
| X axis label help | 10 Apr 2004 04:20 GMT | 2 |
I have created a line chart with four values from cells in sheet 1, sa A1:D1. Each data point corresponds to a different material. Th material names are in cells in sheet 1, say A2:D2. I select those cell with the material names as my category (X) axis labels. The materia
|
| Scatter with Dynamic (Array) Data | 10 Apr 2004 04:09 GMT | 3 |
I'm trying to create a scatter plot using Array's instead of using Cell's in a worksheet but can't seem to get it to work. Here's what I'd LIKE to be able to do but it keeps bombing. Any ideas?
|
| Error bars on histograms | 10 Apr 2004 03:48 GMT | 1 |
Hai All, I am trying hard to incorporate individual error bars on each histogram based on their corresponding values. But i could not succeed in it as the same value is accepted for
|
| Control Charts | 10 Apr 2004 03:43 GMT | 2 |
I need to create a control chart. I have no idea how to do this. I'm looking to create a chart that can distinguish between variation in a process due to common causes and variations de to special causes. I need to show an upper control line, a control line and a lowe
|
| How can run an Excel macro program using DOS command? | 10 Apr 2004 03:26 GMT | 1 |
I want to run an Excel macro program using batch job but I don't know what the DOS command is?
|