I have a calculated chart of price vs date and would like
to create a vertical line indicating current date so that
the progress can be easily checked. Have been unable to
find out how to create a vertical pole. Can someone help?

I have a graph and I have used the drawing line to add a target. It
looks fine on the screen but when I do a print preview or print the
line goes away.  I have another graph with the same type of drawing
line but it will print.  I need to know what to  do to get the drawing

I'm using a scatter plot to chart this data (instead of a line graph
which I recently learned about) but it's still not plotting my dat
correctly.  I want to do a wind speed (x-axis) vs time (y-axis) plot.
have two sets of values for wind speeds, "predicted"  and  "observed

mine is excel 2000
two questins
1.in thecutom tpe chart there is only one userdefined chart called default
the built in is greyed out.

My application needs to display information in a Gantt type chart - one line
for each record; although being able to group them together would be great.
Has anyone got some hints for me on this??
g

I cannot figure out how to automatically have the data points in a scatter plot chart each be individually labeled.  For example (a simple example to show my problem), if I want to plot the following data
Name    Height    Weigh
John       6            15
Bill          5            ...

I'm using Excel 2003.  I cannot find a combination or
custom chart with a stacked bar on the left axis and a
line on the right axis.  I'd like to show dollars on the
left axis and have the S&P 500 or some other index appear

I am using Excell 2000
I am trying to create a scatter chart comparing to our pay
in relations to the midpoints of the wage ranges.
I put the data in Excell the % is where the employee is in

Hi
I am changing the pivot chart but the changes donot get saved. How ca
we make sure that if we r changing the pivot chart options then they
permanent.

Windows 2000
Office 2000
I have several data elements on a chart which is combination lines and columns
(columns are being used strictly for background color).  How can I remove the

I am attempting to create a chart with 5 series (2 bars and 3 lines) but it
seems that the chart can only be created with 2 lines.  Is there some way of
changing one of the bar series to a line series?  I have tried right
clicking on one of the bar series and changing the chart type ...

I have a user with an Excel chart of research data (over
20000 rows) that is to be placed in an Excel chart and
inserted into a Word document.  As you can imagine
rendering such a large amount of data is quite a problem

I have data in 2 columns:
 t     X
 1     11
 1.4   22

Is there a formula to count every occurence of a
character. The following formula counts the number of
cells with the letter 's'. =COUNTIF(A1:F35,"*s*"). I need
to have a count of all occurences of the letter 's'. So

I am involved as an administrator of an adventure race.
The event is 388km (242 miles)in length and I wish to
produce a chart showing the changes in altitude that take
place over the course.