| Thread | Last Post | Replies |
|
| Custom Chart: Stacked Bar & Line | 27 Mar 2005 01:30 GMT | 1 |
I would like to combine a stacked bar graph and line graph. I can do this with a regular bar graph and line graph, but not with a stacked bar graph. Any ideas on how to do this? I will use the same y-axis values for both the line and stacked bar. Thanks, \JG
|
| Program line when charting variances? | 27 Mar 2005 01:24 GMT | 3 |
Is it possible to program a vertical line when charting variances? My Y axis is either variance dollars or variance percentage. My X axis is for what I'm charting variances. For example my X axis could be apple types. In my data series I sort my Y variable from best to worst, and ...
|
| Excel resizing Graphs | 26 Mar 2005 23:56 GMT | 3 |
When I copy and past a graph, excel resizes it. It does not matter if I say move and size with cells or move and don't size with cells. I need to make MANY graphs all of the same size. I created a custom layout, but I then must manually resize every graph. Is there a way to ...
|
| tornado charts | 26 Mar 2005 20:20 GMT | 5 |
I need to do a tornado charts like the ones shown in http://peltiertech.com/Excel/Charts/format.html#tornado but I need Y axes not to show category but real numbers that needs to mantein their relative position (they are ascissas in another scatter plot)
|
| percentage not active?! | 26 Mar 2005 19:25 GMT | 1 |
i have two data series that i want to represent as a stacked 3d column, i want the percentage of each out of the total column height to be shown but the data series option for percentage check mark is not active??!! why is this and how can i add the percntage to the value?. ...
|
| resize chart on copyo | 26 Mar 2005 08:41 GMT | 1 |
1) I'm using Microsoft Office 2003 2) My file is large (26meg) with many graphs (50+) My problem is that all my graphs must be the same size and format so I created one graph that looks exactly the way I want it. The information is
|
| Can't Set XValues for Surface Chart | 26 Mar 2005 08:06 GMT | 1 |
I'm trying to generate a 3D surface plot in VBA. When I try to assign an address range to the XValues property of a seriescollection, I get "unable to set the XValues property of the series class". I am able to set the Name
|
| Alignment of Multiple-Level Category Labels Not Possible? | 26 Mar 2005 08:02 GMT | 1 |
I have multiple-level category labels in my chart. How can I change the alignment of the meta-label level, i.e., the rows of labels below all the other levels. Excel restricts the alignment of this meta-label level at 0% even after manually changing the alignment of the labels on ...
|
| Need specific tick marks on Y axis | 26 Mar 2005 08:00 GMT | 1 |
I am sure this is probably something really easy, but for the life of me I can't seem to figure it out. I tick marks on the y axis from 0 to mark 260 and 420. The biggest that I would need is 600, but I must have the 260 and 420 marked. How do I do that? I tried to change the ...
|
| Another question for Jon | 26 Mar 2005 07:58 GMT | 1 |
Jon - I have a final question. The suggestion you gave me earlier works great, but since my workbook is so bloated, the chart update time is a bit on the sluggish side (for reference, I am using the method you detailed on your website, using a "helper" column that updates ...
|
| getting rid of zero values in a column | 25 Mar 2005 21:03 GMT | 2 |
i have a set of data on a column that i`ll use to plot on a graph and find a trendline for its behaviour...problem is: there is zero values in some cells that were not calculated... i want to copy this data in a new column getting rid of cells with zero value because it results ...
|
| Automatic Graph generation by series | 25 Mar 2005 08:15 GMT | 2 |
In my work book I have a sheet which contains Scheduled installations and successful installations per week. Is there a way to automatically generate a graph depending on the week number?
|
| series address | 25 Mar 2005 00:19 GMT | 4 |
How do I get the series address in VBA? I want to dynamically change the chart title based upon which column is used for the Y-values in an X-Y scatter plot. wazooli
|
| VBA to change size of data labels? | 24 Mar 2005 21:25 GMT | 2 |
I have a chart with text that is too long for the data labels. Looking around online, I see that the data labels cannot be resized manually, and a common recommendation is to replace them with text boxes. I understand this, but isn't there any way to directly control the width of ...
|
| Need some assistance | 24 Mar 2005 20:58 GMT | 2 |
I have a spreadsheet where your are supposed too archive curtain goals, based on different activities. I've got six different colums taht shows the activities, I wanna' have a line that shows how the activites mesures up to the goal.
|