| Thread | Last Post | Replies |
|
| excel's curve-smoothing algorithm | 09 Oct 2007 19:18 GMT | 2 |
I have some raw data in excel, with a smooth curve added. I am trying to reproduce this curve on the same data in GraphPad Prism, with poor results. Does anyone know how excel calculates curve smoothing?
|
| Word/Excel Charts x axis to months | 09 Oct 2007 19:16 GMT | 5 |
I'm trying to format a bar chart which has promotions on the y axis and i would like the x axis to be months of the year NOV, DEC, JAN 08, FEB 08 and so forth instead of numbers 0-7 but I dont know how to change this? The chart has bars across according to which month(s) the ...
|
| What I'd like for Christmas.... | 09 Oct 2007 19:14 GMT | 3 |
Has anyone heard any more about the 2007 service pack? This is an August news item: http://microsoft.blognewschannel.com/archives/2007/08/16/office-2007-service-pac k-1-in-the-works/ Gary Klass
|
| multiple pivotcharts from 1 pivot table? | 09 Oct 2007 19:02 GMT | 4 |
I have a pivot table that I need to generate several charts from and I need for each chart not to change when I change the data in the table. Is there a way to do this? All of these charts will be in the same workbook.
|
| Trendline factor extraction for 6th order | 09 Oct 2007 18:44 GMT | 1 |
I am attempting to extract polonomial factors for a data set. At 6th order, the process falls apart. My data is X=0,100,200,300,400,500,600,700,800,900,100
|
| I need to change a series plotted as a bar/column to a line. | 09 Oct 2007 15:51 GMT | 1 |
I have a datasheet and I need to specify which series are lines and which are bar/columns. How do I do this
|
| How do you create a cascade or waterfall chart | 09 Oct 2007 15:43 GMT | 3 |
I am looking for software tools and/or techniques for creating cascading and waterfall charts . I'm guessing that regular Excel does not do this. What's the best answer?
|
| save pivotchart formatting - colors etc.... | 09 Oct 2007 15:35 GMT | 1 |
how do i keep the formatting - colors and shading etc....
|
| I need to hide points on a line chart if the value is ZERO | 09 Oct 2007 15:16 GMT | 4 |
I'm using a line chart to display my info. I only have to show the points on the graph. I found where to hide the line so only the points show. The only problem is if I have a value of zero it's displaying a point at ZERO on the axis, this is not what I want. I can't find where ...
|
| trying to swap axes on chart | 09 Oct 2007 14:18 GMT | 4 |
Hi, i'm trying to create a basic column chart from two sets of data, one being years and the other being figures. I want the years along the bottom and the figures along the side, with the columns running up from the years showing the trend of how many per year. I can only get
|
| Repeat Values in rows | 09 Oct 2007 12:22 GMT | 4 |
I need to search my worksheet (128 X 128) rows for any repeated values, anyone help?
|
| How to Automate Copying of trendline equation to a cell | 09 Oct 2007 02:14 GMT | 1 |
I want to figure out have excel take an equation for a trendline out of a chart and paste it into a set of cells to calculate new values. For example I have data at time 100, 200, 300 and 500, but want to automatically have the equation of the trendline fitting my data copy over ...
|
| NEED HELP CREATING A CHART | 09 Oct 2007 01:15 GMT | 2 |
I need help. I want my chart to stack data in bars, for example, the total of the bar is 10 and it is split into two categories equalling 8 and 2. I need to show the information in groups of 3 bars and multiple groups on the chart. I know this is not a very good explanation but I ...
|
| Need charts to print in full page | 08 Oct 2007 18:42 GMT | 2 |
It looks simple, but I couldn't figure it out. I have 3 dynamic bar charts side by side and 3 tables of data one below each chart. While everything on this sheet works fine, my issue is printing. This is supposed to be a one-page report. But every time we print it, it prints in
|
| Line Graph in Excel | 08 Oct 2007 16:51 GMT | 5 |
I have created a line graph in Excel (with my input data on a separate worksheet). I have 3 columns: Planned, Actual, and New. I am tracking 'requirements' and I only want 2 lines on the graph. I have plotted the Planned and Actual, however I want the 'New' to be added to the ...
|