| Thread | Last Post | Replies |
|
| how can i select all the cells with same color on a sheet if there are multipale colors by vba code | 15 Dec 2004 17:27 GMT | 1 |
how can i select all the cells with same color on a sheet if there are multipale colors by vba code
|
| how can i graph with log-log scales? | 15 Dec 2004 17:06 GMT | 1 |
I wish to graph pricing curves using a logarithmic x-axis. Is this possible with Excel? If so, how do I do it?
|
| how can i graph with log-log scales? | 15 Dec 2004 16:34 GMT | 1 |
I wish to graph pricing curves using a logarithmic x-axis. Is this possible with Excel? If so, how do I do it?
|
| Help with pivot charts and data labels | 15 Dec 2004 15:09 GMT | 1 |
I have just started using Pivot Charts, and I think they are pretty awesome, but I have come across an issue, and was hoping someone could help me out. I have a bunch of test data that I am plotting, to show results for 3
|
| Updating Chart fails | 15 Dec 2004 13:46 GMT | 1 |
I have problems updating charts in Excel when using VisualBasic to calculate values. I calculate values with a self-written function "func". My sheet looks like this:
|
| Pareto anlaysis | 15 Dec 2004 13:22 GMT | 1 |
How do I set up an excel template to produce a pareto analysis
|
| Can you stop charts from plotting logic statements as 0 | 15 Dec 2004 10:35 GMT | 1 |
I have plotted a graph from a 12 month data table, this table pulls in information from other sheets. The idea is as the data is inputted as the year goes along, the graph automaticaly draws. The problem I have is that as there is a formula in the data cells pulling in the ...
|
| Problem with date base units for x axis | 15 Dec 2004 09:12 GMT | 1 |
The problem is that if you have dates as the X-axis series for a chart, the only options for Base Units are Days, Months or Years. If you have quarterly data, excel adds extra space between the data points. A simple example illustrates the problem:
|
| Formating cell to 1000 | 15 Dec 2004 03:52 GMT | 3 |
Does anyone know a way where I can take a cell and have that number represented times 1000. For example is A1 is 12. I would need this to represendted as 12,000.
|
| how do i reference cells to create a chart? | 15 Dec 2004 03:50 GMT | 1 |
I am compating data over many months in a spreadsheet with a tab for each month. While the data changes from month to month, the format is consistent, mostly for calculation purposes. I would also like to be able to use this to create charts that can be transferred from one ...
|
| Is there a way to have two values (percent and number) in a label. | 15 Dec 2004 03:48 GMT | 1 |
I am trying to format a cell to give the percent value as well as the numeric value from the chart. I tried to format using the "Special " format but it is not giving the correct information. I am using Excel 2003
|
| Fill screen with chartobject by zooming? | 15 Dec 2004 03:42 GMT | 1 |
I have chartobjects in a worksheet and try to make code with commandbar buttons to jump to different chartobjects and zoom in the chartobject to fill the whole screen. Surley this can be done? The command button code is not a problem, it is the zoom 'n fill part that
|
| fold change lines | 15 Dec 2004 03:05 GMT | 3 |
Is there a way to have Excel draw lines representing various fold changes on a log scale scatter plot?
|
| Creating a dynamic chart | 15 Dec 2004 02:52 GMT | 9 |
I posted here a few days ago and was given some ideas on how to do this. However, I seem lost. I have a main worksheet which is updated from several worksheets by using code. On this worksheet is approximately 15-20 columns something like this.
|
| How do I get a trendline for all data series, instead of just one. | 15 Dec 2004 02:04 GMT | 1 |
I need to retrieve R squared values, and trendline information for all data series within a block of data. Excel is only letting me get trendline information on one data series, which is almost useless for me.
|