I have a database where column H2:H89 are the prices homes sold for during a
given period. I would like to create a bar chart with each bar representing
a price range. For instance, I'd like the first vertical bar to be homes
that sold for less than $99,999, next bar $100k-$124,999k ...

When doing a regression analysis I am constrained with the
use of only 16 explanitory variables.  Does anyone know
anyway around this?
Thanks,

I'm using excel 2000
I have a sheet that I want to plot column G vs Col P,  Col P has a large
number of blank cells.  In the spreadsheet, when calculate the mean and
standard deviation, excel is "smart" enough to ignore the blank cells.

I have a 3D area graph. I can see where to put the TITLES for the 3 axis,
but where to input the VALUES for the Y axis. Values for X and X are OK.
The graph puts by itself values such as S201 for Ys which I don't know where
it gets them. The data required for Y are contiguous to the ...

any help appreciated...is it possible to plot a
high/low/close stock chart with an additional series on a
second axis?
for example

I have a spreadsheet that I want to have 50 sheets with
data and 18 different charts referring to the data on each
individual sheet.  The charts on each sheet refer to a
total of 21 different data series from its own sheet.  I

Whenever I create a chart (a line chart in this case), the
Y-Axis scale is absurd.  Here's an example:
X-values:  1   2   3   4   5  
Y-Values:  10  20  30  40  50

Is it possible to change the colors of the data when you drill down (double
clicking on a cell) into a pivot table?
For instance, when I do it now, the source data appears with the header row
in a very light blue, and its underlined.

I have been tasked with showing a graph as a dollar bill broken into pieces
to represent the data.  I have been experimenting but haven't been able to
produce a desired result yet.  Have any of you ever done this or can you
point me in the right direction?

Is there any easier way to change the order of the way
items appear in the legend?  They display in the reverse
order of the way they appear on the chart.

How do I get my legend items to appear in the same order
as the rows on my graph.  They appear in reverse order.

I am having trouble charting a Quarterly Revenue Graph
with Lines and Bars on same graph.
I would like Revenue on Y Axis and Quarters on X Axis.  I
would like 2 base series as bars and 6 other series as

I am creating a series of charts.  I remember someplace to
change to shape of the column to round the corners.  I
can't seem to find at anymore, any help?  I am using excel
2000.  Thank you for any help you can give me.

I need a macro to place the upper left corner of a chart
in the upper left corner of cell B1.  How do I do this?
Any help is appreciated...
C ;-)

I have to plot a line graph with two Y axis. The primary Y axis is
normal scale ranging from 10 to 60 with interval of 10. The secondary Y
axis needs to correspond to the primary axis but in log scale, i.e.
from log10 to log60 with interval of log10.