When using the "invert if negative" function in an excel chart, is it
possible to set a default color for negative numbers (i.e. positive bars will
be Blue and negativ Red)? I know you can change the colors individually, but
have not found a way to make it dynamic. This gets ...

I am trying to draw a bubble chart.
The X values are dates in the next few years. However when the graph i
drawn, these X values are ignored, and Excel uses the row number of th
cell containing the data instead.

I have a line chart which plots data in the range 2100 - 3000
How do I stop the chart having a big blank area from 0 - 2000 ?
thanks
Mike

I am making a graph with columns, where each column represents water use on a
certain time interval. I have 38 time intervals which are, each one, defined
by an initial and final date, such that the final date for one column is
always the initial date for the next column.  

In my pie chart, items are grouping together as other even though there is no
"other" in my budget -- why?  It is actually a cool idea -- how to I add
other items to this "other" (e.g. very small percentages of the pie).

Can you save a chart as a picture?  I know that I can copy the chart by
"shift", "edit" "copy", and then paste it in another document, but can I save
it as a picture.

Is it possible to force an error (like #DIV/0!) to plot as if there was no
information in the cell?  It seems like the default is to plot the error as a
zero.

I have two charts layed over eachother, with one's background completely
transparent, in order to be able to see all the data I want in one visible
chart (I saw that trick on one of the MVP's sites).
So aligning the two charts was already a tedious work, but now I print them

How would I do a hyperbolic trendline?

I have a set of data that tracks the number of changes to a file over
time. I want to show a line chart that I can use to visually locate a
file with a low churn rate. "Low churn rate" could either mean "Has
changed a lot in the past but hasn't changed in a while" or it could

I want to plot a series of X-Y points on a scatter chart
that represent the position of a satellite at a specific
time. X-axis is Right Ascension (RA) and ranges from 0:00:00
to 23:59:59. Y-axis is Declination (Dec) and is -90 to +90.

i need to calculate the area under a curve in MS excel, but there does not
appear to be function that does this. Have i missed it? I have used SPSS too,
but it also doesn't appear to calculate it. i have check both programs' help
databases, both online and offline.

I am doing charts in excel and importing question titles as category x-axis
labels through data source but it is aligning some centre and some to the
right. I have done all the usual things (double clicking on text and chosing
align tab, aligning in the data source table) but ...

am I missing some part of excel as I cannot make a chart ( even the simple
ones) the points do not show in the plot area, ( or maybe I am doing some
thing really stupid...it sure feels that way at this point!

Excel 2002 -
I have a line chart with 5 data sources.  I would like to add a
dropline when 2 data sources cross each other.  Is this possible?