| Thread | Last Post | Replies |
|
| Personal Preferences | 30 Jul 2004 22:42 GMT | 1 |
I added a chart someone had given me to my chart choices and named it as my default chart and now any time I create any kind of chart it looks like the one I loaded. How do I erase what I did so that this chart doesn't exist any
|
| Dynamic Chart Help! | 30 Jul 2004 14:44 GMT | 2 |
I want to create a line chart showing monthly data from April 2001 up t and including the current month. (ie, my data will be expanding eac month.) I currently receive the data in a spreadsheet and any month that ha
|
| question about format axes | 30 Jul 2004 03:06 GMT | 3 |
I make a chart graphic (scater X,Y) I want to make format for axes ,so I open the format axes and chose the scales , I put the value in the text minimum , maximum... etc
|
| Conditional Datapoint Formatting | 30 Jul 2004 03:00 GMT | 1 |
I'm graphing time series data values in weekly buckets. I'd like to d 2 things that involve conditional formatting of a specific datapoin within the series. -I'd like the datapoint of the most recent week to have a differen
|
| Global settings for all charts in a workbook | 30 Jul 2004 00:11 GMT | 6 |
Hi all, LTNS (Yep, I'm back) - I have a workbook (XL97) containing 44 charts, each in its own worksheet. I would like to find a way to standardize the settings for all charts in the workbook. That is, I want to apply uniform formatting
|
| Plotting a delta function | 29 Jul 2004 22:00 GMT | 2 |
I want to plot a delta function using Excel i.e the function is o finite value only at a single point and zero elsewhere. Normally, sinc the value is so high that it completely masks out all other plots i the same chart, an upward or downward facing arrow (of a reasonabl
|
| How to determine time constant | 29 Jul 2004 21:38 GMT | 1 |
I was wondering if there was a way to determine the time constant of an exponential curve on chart.
|
| copy and paste values | 29 Jul 2004 17:46 GMT | 1 |
I have an exelsheet with 9 graphs. This has become a huge file (20MB). I have to mail the graphs. Is there a possibility to make the file smaller (like copy/paste values, something I already did with the data on the
|
| Trap error for trendline clear button? | 29 Jul 2004 17:22 GMT | 1 |
I have 2 data series on an XY scattergraph. I have created buttons for turning the associated trendlines ON/OFF. Trendline 1 is the trendline for series 1. The sheet opens with trendline 1 on and trendline 2 off
|
| Automatic Dynamic Chart Ranges | 29 Jul 2004 17:12 GMT | 2 |
I have an XY plot that refers to a set range of values on my worksheet In this case, it is 8 rows long. I chose 8 rows because that is th maximum number of data points that I will ever need. I have set up th chart values so that they are dynamically calculated based on VLOOKUP
|
| Displaying Trend Data which includes zero values | 29 Jul 2004 12:27 GMT | 1 |
I am creating trend charts which looks at monthly data from the yea 2000. My data table is set up from April 2000 to March 2005. The chart are set up to read all this data, so that when the monthly data i updated the charts are automatically updated with all the values t
|
| Runtime Error 1004 - setting name as a source of chart | 29 Jul 2004 12:22 GMT | 3 |
Dim TrendChart As Variant, sourcedata As Variant, i As Integer, n A Integer, j As Integer ActiveWorkbook.Names.Add Name:="CSource_1" RefersToR1C1:="'1'!R1C26:INDEX('1'!C27,COUNTA('1'!C26))"
|
| my previous question | 29 Jul 2004 03:08 GMT | 6 |
I got the following reply to my question, thanks a lot! ...but I have one more question, I was wondering how I can delete all those unnecessary empty rows in the table after I've converted it? (a lot of empty rows
|
| Interpreting Data | 29 Jul 2004 02:15 GMT | 1 |
I am trying to convert some data into percentages in an excel spreadsheet. For example, the spreadsheet asks a question, the data is good, fair, excellent and about right. I am trying to convert those answers into
|
| Shapes | 28 Jul 2004 23:21 GMT | 1 |
I have a map of the united states on a tab in my workbook I ahve another tab that has information about doctors. It tells the doctors name and gives some demographic information about them. Each state is it's own shape. When i click on that shape i want to be able to do some ...
|