That is great Jon, thanks. But I am still perplexed. My program does th
following: I have 4 columms of data (Dates, stock prices
recommendations, target price):1) It graphs the Dates and stock pric
columms, 2) when it finds data in the Recommendations columm, i

I've been trying to plot data on a probability scale for the x-axis.  I have found no template scale for this, so my next choice is to create a scale, likely using a formula.  Is this possible?  Thanks.

I have a bar chart I am making in which one series of data
is much larger than the others (say 30,000 units versus
1,000 units). When I chart it I get one very long bar for
the 30,000 units and a buch of small bars for the other

I recently saw some Excel charts designed to look like
fuel guages - does anyone know where I can get some help
on producing these.
Thanks,

Is there an easy way to shade the area between two series of data on a
graph?  Using an area graph, I can get it so that it shades from a line
downward, but I can't figure out how to shade between lines.  (The lines for
the two series cross more than once.)  Thanks.

i am having continuing problems with the following:
I have a spreadsheet which lists project status. One of
the columns shows the installation subcontractor.
I want to have a drop down box where you select the

My Data is something like this:
                              2002     2003
Software sales         500       800
Services Sales         4000      6000

i need to know how to select certain data points on a scatter graph, s
i can create a linear trend line just for those points
--
Message posted from http://www.ExcelForum.com

Am having a problem with combination charts.  Excell insists on dirtributing
8 sets of data evenly as 4 blocks and four lines.
Am aware of secondary axis and have one, but reallocation of data set to
secondary axis results in a very wide block rather than a line.

I'm using an XY Scatter chart and I want to draw a
straight line between 2 points which passes through a 3rd
point on the chart. The line represents the Security
Market Line (relating risk and return) with Standard

I have data consisting of different names of offices we
have and the amount of claims they submit to us each month.
  +------------+-Jan-+-Feb-+
  | New York   | 10  | 20  |

I am using Excel 2000 and creating an XY scatter chart. I
can create a horizontal line easily enough, how can I
place a verticle line or series in the chart in an exact
location? I'm wanting to represent a verticle line at 4.5

Im having some problems with my Excel chart. It will not plot Net Income vs Year. It keeps trying to treat Year as a different data series. It will work if I use text i.e. a1990, a1991, etc. but it refuses to use 1990, 1991... Any Ideas???

Hi, all,
I've been using Excel for about 10 years.  I'm using
Excel 2003 on Win XP for the first time.  I'm used to
differences when going from one release to the next.  

When I plot in excel and remove the title and leave it
blank, the entire graph is completely flat.  When i put
any title in the graph shows up as it should.  Can someone
please help.  how do i fix this and why is it doing this?