How do I change the color or format of a line and/or bar so that negative
numbers in a data series are displayed differently.
Specifically, I would like to draw more attention to a series when it
crosses the -0- line because this particular chart displays 4 separate

Does anyone know how to make a combination chart of a stock chart and a line
chart ?
Thanks,
Hiromichi

Dose anyone know how to combine stock chart and line chart together ?
Thanks,
Hiromichi

I've started trying to use Excel's contour charts but the results are
very poor and I'm not too sure how to improve them.
a) There is always a massive gap around my chart.  All I get is a
narrow rectangle in the middle of the screen with loads of empty white

I am trying to create a scatterplot chart where the axis points begin
in the upper right hand corner instead of the bottom left.  Is this
possible in Excel?
TIA!

I want to do a Clustered Column or Stacked Column chart with a line above the
columns that represents a maximum, like total available hours for the
timeframe represented by the columns.

=LOOKUP(Sheet2!A2:A10,"*"&C1&"*",Sheet2!B2:B10)
This resides in Sheet1, C1 is a cell that I type the search 'target' into,
so it changes as needed.  I get a #VALUE! error.

I need to make a chart on how many times the data in one column occurs.  
There doesn't seem to be a chart built into excel that does that. I'm kind of
desperate, so if anyone has any idea I would REALLY appreciate the help.
Thanks!  Donna

Id like to be able to freeze the very first row for headers and freeze the
very bottom row for totals only and be able to scroll thru the rows in
between can i do this?

Is it possible to imped/overlay one chart on another, and have them both be
fully functional?  For example, I would like to put a second small chart,
about 1/4th size, on a full-sized chart.
Thanks,

I have a data range that I am charting to show percentage of total of the
various data categories.  The problem is there are a lot of categories under
2% I wish to combine into 1 entitled 'Misc'  
Does anyone know a way to combine several data points into one.

Jon - I think this question is directed towards you.  I have implemented a
version of your broken y-axis scheme.  My data looks like the following:
sample                             average                  avedev
negative control    0.36252361         0.029793573

Hiya,
Is there an easy way to unlink a chart from its source data?  I have 6
charts generated from a large spreadsheet in excel 97.  I send these charts
on by email to others and I want to be able to send the charts without the

I have a question about an Excel chart. I have a series of graphs which
compare a number of factors relating to "card swipe" data. This relates
to data plotting on an X (horizontal) and Y (vertical) axis graph. The
X axis represents the month of the year. The Y axis is the "data ...

I've tried to set the major tick for my x-axis to none, so that the marks
only show up above my data points along the x-axis... it is not working
I notice a small change from None to Cross, but it basically looks the same
as cross, just a little bit shorter on both ends(inside and ...