| Thread | Last Post | Replies |
|
| Unusual Chart Type? | 05 May 2004 14:49 GMT | 2 |
I am running Excel2000. I wish to create a chart that does not seem t be supported in Excel. The data consists of a table of dates an ?states? (let?s call them A, B, C, D and E). One column is dates an the next is states. Dates will be in order. A given date could hav
|
| plotting more than 32,000 points | 05 May 2004 14:49 GMT | 2 |
I have 60,000 data points which I need to plot. What I would rather d is plot every other point, creating 30,000 plot points. Is thi possible. Is there a way to copy and paste every other row to a adjacent column without hand selecting each one
|
| How to suppress zeros | 05 May 2004 14:46 GMT | 4 |
I have data that includes zero values. How do I stop these zero values being plotted on a chart? Thanks Jonathan
|
| Absolute Maximum | 05 May 2004 14:45 GMT | 2 |
Can some one please show me how to find the absolute maximum (x & y) from a 4th order polynomial equation... Excel tells me the equation is; Y=-0.007x?+0.0321x?-0.4409x+3.6696
|
| Custom chart problems | 05 May 2004 14:13 GMT | 1 |
In creating a custom chart, Excel doesn't seem to keep the border an chart background settings at "None"...all the other formatting i retained (fonts, etc.), but the chart always reverts to a solid whit background and a thin black border around the chart. I have to go i
|
| 2 unequal sets of data charted on secondary and primary axis | 05 May 2004 14:03 GMT | 1 |
I have 2 sets of data (order qty and forecast qty) that I would like to chart on a line graph. x-axis by month, y-axis by quantity. The forecast qty line would run along the entire x-axis for the 12 months. However, the order qty line would only be filled in at the end of
|
| Frequency | 05 May 2004 14:01 GMT | 1 |
I'm using excel with phstat add-in. How do I graph so that the units of the variable are along the x-axis and just the count or frequency is along the y-axis? Secondly, how would I get excel to plot or i.d. the mean and the standard
|
| data label bug? | 05 May 2004 13:57 GMT | 1 |
I created a conditional chart which shows two different types of columns... one column type shows actual # days to sign a contract, and the other shows contracts that are still pending and # days it's taken so far. they are set up conditionally so that they only display one type ...
|
| chart with date/time values | 05 May 2004 13:51 GMT | 5 |
I would to realize with excel an X/Y line diagram where on the X axis I would put a date/time value. There is anyone that know how to do this? We suppose of having to represent these data
|
| Automatically, and independently, change bar colour dependant on result | 05 May 2004 13:41 GMT | 2 |
Another one for you to wrestle with.... Plotting performance results on a monthly basis I need to change th colour of the particular months bar dependant on its perfromanc against the target.
|
| Convert Chart Series Formula to Array Via VBA? | 05 May 2004 04:53 GMT | 1 |
I am trying to convert the Chart series formula below to an array via VBA. I have tried recording a macro and have had no success. I used the select series, click in the formula bar and hit F9 and this does not work. Can anyone help?
|
| Embed data in graph | 05 May 2004 04:39 GMT | 5 |
I am using excel with phstat add-in to create the mean, median and mode for some data. The mean, median, and mode occupy 6 rows and two columns in the spreadsheet. These 6 rows/2 columns are what I need to embed as a legend or a note into a graph. The graph is from the same ...
|
| link from chart data point to data (mousedown) | 04 May 2004 18:53 GMT | 4 |
I want to link all the points in my xychart with the rows of the data that are in the chart. i.e. after a mouseclick on the chart data the user will be redirected to the data row The idea is to create a link to a text cell, situated in the same row as the data, which explains the ...
|
| Pie within Pie chart | 04 May 2004 17:28 GMT | 1 |
I need help in plotting pie within pie chart Canada- 82% US- 18% within Canada I have to show the division 82% within
|
| column graphs | 04 May 2004 17:24 GMT | 1 |
How do I make a XY type column graph? I wish to add data to a column graph and have it plotted at the correct X interval Thanks
|