| Thread | Last Post | Replies |
|
| Plotting every Xth point only | 31 Aug 2004 15:44 GMT | 8 |
I have some very large data sets which I wish to plot. This however produces very large (and not very pretty) graphs (my data set consits of points every 0.1 seconds for 1 hour).
|
| 3-D Scatter Diagrams | 31 Aug 2004 15:28 GMT | 2 |
I have frequently used 2-D Scatter diagrams within Excel and used trend lines etc. Now want to do 3-D Scatter diagram with a trend surface rather than trend line.
|
| zooming? | 31 Aug 2004 15:21 GMT | 4 |
Hi Is this the term i should use? I have trying to enable my chart to have a zoom effect. My x-axis is based on date(time). How can i zoom in the
|
| How to save chart | 31 Aug 2004 11:14 GMT | 2 |
Do not use the chart feature regularly Have a simple time series I want to chart When I set the chart using the wizard all works fine When I am asked what location I want I do not use the embedded option so I
|
| Error bars | 31 Aug 2004 08:03 GMT | 2 |
In a clustered column chart, how do you apply a different error bar for the standard deviation of each data set? At the moment I can only apply an error bar of the same value to each set of data. Thank you
|
| Plot Temp over time | 31 Aug 2004 05:04 GMT | 1 |
I have a spreadsheet with columns for RunID,RampTemp,RampTime,DwellTemp,DwellTime,CoolDownTemp,Co olDownTime.I want to plot the different Temp(s) over Time for each RunID. Can I do this in Excel and how?
|
| How do I draw a line equation in Excel | 31 Aug 2004 04:50 GMT | 2 |
I want to draw the graph:y=100*2.71^(0,231*x). How do I will do it in Excel?
|
| if worksheet function | 30 Aug 2004 11:50 GMT | 1 |
I was just wondering whether it is possible to create a simple if statement where the text, depending on if it is true or not, comes up in the cell a different colour.
|
| "Pop-up" charts activated on hover | 29 Aug 2004 14:24 GMT | 5 |
I'd like to have charts pop up when the user hovers over the source data. For instance, I have several sections of sales data in this form: Jan Feb Mar Q1 Apr May ...
|
| how do I remove the "0" in front of a decimal point? | 28 Aug 2004 19:54 GMT | 1 |
I'm trying to construct a correlation table, but every time I put in a value that is not statistically significant a "0" pops in front of the decimal when I press enter. Is there a way to stop this? I'm finding excel very easy to use otherwise. I'd hate to start all over again.
|
| Show data table | 27 Aug 2004 22:58 GMT | 2 |
I am using Excel in Office 2003. Under chart opition I swelect 'show data table' Can I edit that table? In the data table that appears I want to add letters after the numbers.
|
| How can I apply a CMYK color to a chart? | 27 Aug 2004 22:55 GMT | 2 |
We use corporate colors to our bar charts. I usually copy and paste the chart into Illustrator and then edit separately each part of the chart. But, is there a way to apply directly on the Excell a cmyk color or a pantone? When I copy and paste a chart on Illustrator I have ...
|
| Charting cells with the same data in them to one chart bar | 27 Aug 2004 22:50 GMT | 1 |
I have several cells that all have a "total" of 1 adn like 5 with different totals, I want a way for the pie chart (or what ever chart) to graph the totals and all the ones with "1" to come up as 1 pie slice with all the
|
| Chart Source Data Formats | 27 Aug 2004 22:33 GMT | 5 |
We currenlty use Excel Charts where the Source Data is linked to anothe workbook. The Number Formats are not carried over correctly from thi Workbook unless both Workbooks are open at the same time-however th values are not affected by this and do not require the other Workboo
|
| Adding Text to Charts | 27 Aug 2004 22:30 GMT | 8 |
I have created a chart in Excel that tracks one of the stock indexes. I have been able to point arrows to specific days and add text so I know what was the reason the stock index was up or down on that day.
|