| Thread | Last Post | Replies |
|
| Line Graphs, X-axis | 14 Sep 2004 18:31 GMT | 4 |
I'm trying to draw a line graph where the X-axis is represented by date and time. From the left to right, my points go from 20-seconds apart to 5-minutes apart. However, my Excel graph shows all the points equidistant
|
| Legend - order of entries | 14 Sep 2004 18:17 GMT | 1 |
I have the data series in order and the legend entries follow this, but I now see that the legend text is not in the good alphabetic & datewise order I wish. ow can I move a legend entry up / down the list without moving the
|
| go from one chart to another | 14 Sep 2004 18:14 GMT | 4 |
I am using the same data that Darell posted...since what I want is similar yet.... I have 20 departments with 4 regional managers looking after them.
|
| How do I format column labels? | 14 Sep 2004 10:57 GMT | 1 |
A spreadsheet is showing the column headers in numbers. How can I change them back to letters?
|
| Charts - Average line | 14 Sep 2004 03:22 GMT | 1 |
How do I put a straight average line (previous years' average) on a bar chart that also has a trendline?
|
| plotting cells that contain "" | 13 Sep 2004 21:36 GMT | 3 |
I have a table that has formulas such as the following in it: =IF($L21>NewStats!$B$47,"",SUM(B$8:B21)) The table keeps a running total based on individual
|
| Dual Goal Lines | 13 Sep 2004 19:55 GMT | 2 |
I'm using a smooth line chart and I have two goal lines each goal for a combination of two production lines (Blue) or a single production line (Green). I also have one line that contains that days set point and this line is used
|
| Column chart Excel 2003 | 13 Sep 2004 13:24 GMT | 3 |
I know that you can paste a picture (e.g. a picture of a pen) into the Column of a Column chart by either simply copying/pasting the picture or as a fill effect-picture... The problem I have is that I have a fill effect for the whole chart area,
|
| Plotting XY values in a chart | 13 Sep 2004 13:09 GMT | 2 |
Hey there, I am trying to plot specific values on the X and Y axis and when I use the chart wizard it creates two lines with the Y values being generic preselected values. Can someone help?
|
| Can Excel generate a 3-D scatter plot? | 13 Sep 2004 06:22 GMT | 1 |
I want to generate surface plots of the form (x,y,f(x,y)). Should I just go buy MathCAD, or can Excel manage this?
|
| How can I plot multiple data sets in a stacked bar chart? | 13 Sep 2004 01:28 GMT | 1 |
I need a chart with stacked columns of multiple data sets, measured over time. The standard stacked-column chart puts all the data from a single time in one column, but I need to see the different sets plotted in separate columns.
|
| I wrapped a two line cell. I sorted but the wrapped cell didn't g. | 11 Sep 2004 20:44 GMT | 2 |
I am putting a list of names on excell. Some have to go on two lines in one cell. I wrapped that cell. But when I sort data from ascending to descending the wrapped cell does not go with that info. Any suggestions
|
| Protection for Chart | 11 Sep 2004 20:42 GMT | 4 |
I have a zoom feature for my chart. There is a spinner on my chart, s when i increase or decrease the value of the spinner, a macro execute and assigns new numbers to the scale of the graph. But the problem is when the chartsheet is protected, I cannot assign new numbers to th
|
| Selecting a region of an Excel plot to calculate the line functio. | 11 Sep 2004 02:08 GMT | 1 |
Is there a way to calculate a line function for a segment of a curve directly from the graph? I'd like to check changes in slope in different regions of the plot without have to regroup my data set.
|
| Changing format of a particular point in a series (conditionally/vba) | 11 Sep 2004 01:58 GMT | 4 |
I have a single series which is charted each month and want to automatically format one of the points (a bar) a different colour. Is it possible to do this automatically? thanks for any advice
|