| Thread | Last Post | Replies |
|
| Suppressing Plotted Zeros in Series | 04 Oct 2005 02:54 GMT | 3 |
Looking at other posts, within a formula returning #N/A instead of zero works well in omitting that point plotted. I have additional formulas else ware that require a zero displayed where #N/A fouls things up. Is there another way to suppress plotting zeros in a series?
|
| Create a stacked, clustered column layout in excel? | 03 Oct 2005 23:19 GMT | 1 |
I need to create a stacked, clustered column that will be in a presentation for my boss ... the best that I have been able to do is to manually draw the 3-D rectangles and superimpose them over the original chart. Any kind of help would be fantastic, Thanks!
|
| clustered stack column charts | 03 Oct 2005 23:17 GMT | 3 |
I am trying to create a chart with three stacks in two columns. I tried using the method described by Bernard Liengmen's but it doesn't allow me to add a secondary axis for the last (sixth) data series. I don't get it???
|
| stop chart series from updating | 03 Oct 2005 20:26 GMT | 1 |
I have created a chart and now want to change the data it uses as the source, BUT I do not want my original chart to update as I want to create a different chart. Does anyone know to freeze the chart so it is no longer linked to the cells?
|
| 2 y-axis want to use a macro to tighten the range on both | 03 Oct 2005 20:20 GMT | 1 |
is there a way i can tighten the range using a macro for two y-axis in the same chart.
|
| Histograms\Excel 2000 | 03 Oct 2005 20:18 GMT | 1 |
Creating either a character or numeric histogram using Excel 2000. Any help or information is appreciated. Thanks.
|
| Appending Values in the Legend | 03 Oct 2005 20:17 GMT | 1 |
Is there a way to append a series value behind the series description text in a legend?
|
| Speed up the process | 03 Oct 2005 18:40 GMT | 2 |
I have this code which can plot any formula with two variables, ie x + y = 0 The code takes the x values from A1:A2 and loops till y is found. This takes a while, so is there a way to speed this code. Sub PlotXY()
|
| Can I setup mixed bar chart where last column is stacked? | 03 Oct 2005 16:35 GMT | 1 |
I have been given a report that need "tweaking". A standard 2D bar chart has several columns that are to be merged together to create a single stacked "Others" entry - whilst maintaining the other columns as single entries. Can this be done?
|
| Breakeven Chart | 03 Oct 2005 14:20 GMT | 2 |
I am trying to create a breakeven chart with the expenses as an area chart and the revenue as a line. Is there a way to mix a line and an area chart on one chart?
|
| continue to reinstall microsoft office? | 03 Oct 2005 12:10 GMT | 2 |
why do I have to continue to reinstall microsoft office small business edition 2003 everytime I want to run excel?
|
| Pivot Chart Report - formatting | 03 Oct 2005 12:05 GMT | 2 |
I've selected TWO options that I put into my 'row' when I created this chart. Is there any way I can reverse the way the two are appearing on the chart? Current example: John's Best Dance Moves Kelly's Best Dance Moves Desired example: Kelly's Best Dance Moves ...
|
| Too much white space to the right of a pie chart! How to eliminate | 02 Oct 2005 09:02 GMT | 1 |
No matter what I try, the right 1/3 of the area in my pie chart b0x/window is white space. If I try to resize the pie chart window, it simply shrinks the pie chart and retains the extra white space. Please help!
|
| How to prevent Excel 2003 from automatically change chart type | 01 Oct 2005 14:57 GMT | 2 |
At the occurence of a blank cell in the series of X values of an XY chart, the chart automatically change to a line chart (which is useless in the context). This drastically reduces the efficiency of Excel, for example: 1) I have to use double records of data, one containing ...
|
| automaic "nice" display of the labels in a pie chart | 01 Oct 2005 14:50 GMT | 1 |
I have a simple but very annoying problem: Let's say you have a pie chart linked to a 2 cols/5 rows array. I display the labels, the % and the value for each part of the pie. My problem is the following:
|