| Thread | Last Post | Replies |
|
| move the point horizontally if it lie on top of the other point | 16 Jan 2004 17:41 GMT | 3 |
I am trying to plot a line chart with a primary axis as category X axis (there are 4 categories) and a value Y axis. I don't want any line to connect the points. I just have
|
| Newbie - Insert picture and lock to cell | 16 Jan 2004 16:12 GMT | 2 |
Is there a way of inserting a picture into a specific cell rather than having it as a 'floating' image, not locked to a cell?
|
| If-formula in series-range of chart-datasource | 16 Jan 2004 15:46 GMT | 5 |
depending on the "True" or "False"-value of a checkbox in a worksheet, I need to show one or the other dataseries for the X-axis in an XL-chart. However, when I try to integrate an If-formula into the series-definition in the datasource-dialogbox, Excel doesn't accept that.
|
| Excel charts in print preview distorted. | 16 Jan 2004 14:38 GMT | 1 |
I'm assisting a customer with an excel presentation she created on another computer. She is curently using Excel XP and she changed some of the data the charts are pulling from and now the charts are all distorted in print
|
| Graph | 16 Jan 2004 14:32 GMT | 3 |
I have a graph in excel and I am required to find the area below the line of the graph. Usually I would add a trendline and the integrate the function to find the area, however the graph is fairly complex and I was
|
| Trendline equation positioning | 16 Jan 2004 12:35 GMT | 2 |
Is it possible to specify (using VBA I guess) the positioning of the trendline equation that can be displayed on a chart? The reason is that, it seems, when the chart's source data changes and re-scaling occurs, the equation gets moved around the chart. If
|
| millions | 16 Jan 2004 12:23 GMT | 2 |
The minimum and maximum y-axis numbers for my chart are $1,000,000 and $100,000,000. Is there a Custom font Category that will format these to appear as $1.0M and $100.0M as y-axis labels? (I know I can make a new column and divide by 1,000,000 ... just wondering if you could do ...
|
| Wireframe Contour plots - labelling contours | 16 Jan 2004 09:17 GMT | 3 |
Hi I have a plot generated in three dimensions. i changed the chart type to wireframe contour plot, where the contours show Z values as functions of the X and Y values.
|
| Number Range as X-axis | 16 Jan 2004 04:56 GMT | 8 |
I need to graph this function (something like f(x) = x^3+x^2+x+4) where the x values are ranging from 0 to 20 inclusive. How can I set the x values to range from 0 to 20 so that it will give me a graph of f(x) with all possible x values from 0 to 20??
|
| Logarithmic trendline unavailable | 16 Jan 2004 00:08 GMT | 2 |
I have an X-Y scatterplot and would like to plot a trendline. The physics of the problem imply a logarithmic decay. When I try to add a trendline, the logarithmic option is not highlighted and hence unavailable to
|
| Static Chart using Pivot Table and other data | 15 Jan 2004 21:42 GMT | 1 |
Using Excel 2000, I am trying to create a Static Chart where the source data is a pivot table and data from a couple of adjacent columns. In the past I have been able to do this. My latest chart is automatically creating a Pivot Chart without the adjacent data. How do I prevent ...
|
| Pie chart - Showing Label AND Value | 15 Jan 2004 18:07 GMT | 9 |
Windows 2000 Office 2000 I have a pie chart with the distribution of volumes by region. The labelling options in Excel will let me choose to show value, label, or label and %. I want
|
| Series as labels on bar chart | 15 Jan 2004 17:45 GMT | 3 |
Windows 2000 Office 2000 I have a series of numbers which represent a percentage of shipments for various countries. I am showing this percentage in a bar chart. I have been asked to add
|
| Micorosoft 2000 chart options | 15 Jan 2004 17:23 GMT | 1 |
Does anyone know how to combine a Cluster Column Chart with a Stacked Column Chart? I want to have a stacked column chart of two group's performances for the month, compared with the two groups total plan for the month
|
| chart hide number in Y axis | 15 Jan 2004 17:16 GMT | 1 |
Hello I would like to do the following : in the axis of a graph : show the numbers from 1-100, hide the numbers 100-500 and show 500-600
|