Just a little variation over the theme of the 3ad of last week:
I've got a *scatter* chart that takes values from cells A1:B100
In C1 and in D1 I've got two combobox (created with data validation method),
each one allows me to choose 4 different parameters. By changing these

Hi All......
I have code below, that after I autofilter and copy results over to another
sheet, will go to AA9 and AE9 as the first cells in Series1 and Series2
sources...that works fine, except I never know where the bottom of the column

is it possible to place a watermark on an excel chart? i have managed to
"fudge it" with a jpeg in the plot area, but i would prefer a better way, if
there is one.

I have a chart that refers to a certain range (for the sake of arguement,
let's say "A1:C5") for its source data.
I now want to insert more data.  Say before row 2.  So I do a row insert,
then add my data.  So now the range the chart SHOULD look at is A1:C6.  But

Using Excel 2000, does anyone know if it is possible to have the columns for
each of 2 different data series be of different widths?
Rather than have the columns for each side-by-side, I wanted to have them on
top of each other, but with the “top” series narrower 5than the other ...

I have several columns with data. In one column I do not have data for every
row. In the line charts, those "zero" values are plotted and connected with
the previous data point. Instead I would rather have a broken line.

I have charts with several series and the legend shows all
series. Is there a way to delete one or more series only
from the legend, but still have the data for those series
still show on the chart?

The ends of my y-axis labels are always cut off when I am making a graph in
either Excel or PowerPoint.  I usually add an extra period at the end of my
label just to get the entire label I want to appear, but often it results in
half of the extra period being displayed also, ...

I am trying to split dates into different cells for a chart however when the
month is formated for text it always reads January. Any help please

I wrote this question several days ago, but was not able to get a solution to
the problem.  Apologies for repeating it, but I am still hopeful that someone
knows how to do this.  It seems like an important aspect of using charts, and
Excel *certainly* must have a way of dealing ...

I am trying to do a simple scatter chart where one column of numbers
represents the series for the X-axis and another represents the y-axis and
the plots are the combined points.
I would like to assign a label to each point to make them easily

Is there an automatic backup copy functionality in excel?  I know there
is an automatic recovery feature, but I can't find an auto backup.  I'm
looking for a function, like in word, that automatically creates a
backup copy of your file.

I want to create a timeline to show when persons were born and when they
died. I can then compare their life spans.

The title box cannot be sized. I must reduce the font to very small to
prevent truncating the title.
I would have thought I could drag the box to the size I wanted but I do not
get the chance to do so.

I have data for the quarter that looks like this:
PRODUCT LINE              Jan Forecast    Jan Actual    Jan % of Fcst
PERSONALIZED IMPACTCARDS    2,921,347    2,017,000        69%
I would like a bar chart to show (in bars) the forecast and actual, and a