I have been searching for a way to limit the number of
symbols in an xy plot.  When I have a couple of columns of
several hundred points that I want to plot on the same
chart, I need a way to differentiate them in black and

I have data for individuals for each week.  I want to hide
all rows that have 0.00 for their weekly total:
Employee   Project   Month       Hours
100201     10501     2/1/2003   42.0

Using Office XL.  I am copying graphs from Excel to a Word
document.  The copy command does pick-up the graph area
and pastes over to Word.  However, consistently it will
drop one or two legends/text boxes in the copying

What reason could there be for the chart button to be
greyed out when trying to create a pie chart from a series
of highlighted numbers?
It's a shared Excel 2000 workbook.

Is there a way to plot scattergrams in Excel? What I mean by
scattergrams (or are they called dot plots?) are plots which similar
to box-whiskers-plots but instead just plot the values and maybe the
median and/or mean as a line. My data are several columns of values

I am working on adding a trendline to a line chart in excel.  Currently,
I am using Microsoft Excel 2000.  I cannot seem to view the data points
for the trendline, only the data points for the lines that I am
graphing.  Any ideas on how I can get the data points on the trendline

For a series of closing index prices like:
104, 104.28, 104.57, 104.9, 105.27, 105.5, 105.41, 104.26, 105.04, 104.86,
103.54, 103.35, 103.58, 103.63, 105.04
105.18, 105.4, 105.3, 105.99, 105.76, 105.84, 106.4, 105.66, 105.18, 105.15,

I'm hoping someone out there can help me.
I've set up a chart using dynamic ranges with the X axis showing dates.
I would like add a target line to the chart, but without having to
make multiple entries of the same target amount.

I am trying draw line charts with a broken/offset x-axis
with the x-axis being on a time-scale.
I am mainly trying to show time kinetics of immune data at
first few time points (2, 5, 9 and 12 weeks) and then

Just wondered if someone could help me with a problem I've
got with an excel chart.
I have a column chart which is linked to a lookup table
which shows amounts spent by month. If the amount spent is

I've created a Geographic Map using Excel '97.  When the
Map wizard starts it interrogates my data and offers
suggestions on zip codes not in the current zip code file
(I'm assuming there's a zip code file somewhere).  How do

I am trying draw line charts with a broken/offset x-axis
with the x-axis being on a time-scale.
I am mainly trying to show time kinetics of immune data at
first few time points (2, 5, 9 and 12 weeks) and then

I am trying to build a single column type graph.
There are 4 categories of values to graph.
Each category has a maximum and minimum value, which will
be different values.

I have some credit ratings for a company and they are
changing over time. Credit ratings are in the form AAA,
AA, A, BBB, BB, B, CCC, CC, C, with AAA being the highest
and C the lowest. I want to plot how the company's rating

I want to graph a range that is automatically updated, but
the range consists of formulae that do not have values
yet. I am doing a line chart, so I do not want these
values represented as zero, instead I would like to