Hello, All!
While ruminating on missing (IMHO) features in Excel, it
occurred to me to wonder if anyone has written a history of
spreadsheets? I did not become familiar with multipurpose

Can I automate an excel worksheet such that if ,say, "436" is written in a
certain cell it shades that row yellow, or if "437" is in that cell it
shades the row blue. It would then be easy to visually tell in an excel
chart which lines belonged to ,say, specific companies.

There must be some command which tells a new chart to randomize colors and
symbols- this can look junky.  I would llike to find a way to change all
symbols simultaneouly to various shapes until I find what makes the chart
most read-able.

I want to shade the area between 2 line plots i.e maximum curve and minimum
curve. Everything in between the two lines is valid. thus the area needs to
be shaded to create an envelop effect.
anyone ever done this before

MS Excel allows users to create a trendline on a plot
based on a number of points. One option to display is the
equation for the trendline that was created. How can I
extract this equation?? I know copying and pasting the

I would like to make a graph combining customer sales margin and sales volume
so that customer sales margin data is on the charts y-axis and customer sales
volume is described by the width of the customer's column on the x-axis. Any
tips on how this could be done?

Can anyone help?
I am trying to create a chart that contrasts size by laying 3 different
sized circles on top of each other (so it will basically look like a shooting
target). I know i can represent this data in other ways but this will have

How do you create a multiple pie chart?
e.g. if you have 3 groups A, B and C, each which 3 different category X, Y
and Z.
Is it possible to put it all into one chart?

I I'm trying to change the format a chart has by default. Basically what I'm
trying to change is the grey background in the chart area, making it white by
default on any new workbook I make a chart on. Can this be done?
Thanks in advance,

Doing microhardness analysis, we need to identify a specific point of
the curve. So I need to know what is the x value that would correspond
to a specific and predifined Y value of the curve.
The usual way to express this would be to have an horizontal line from

I've got a pivot chart which has X = Total Sales, Y = Product Code, and Data
Series = Year&Month; from a pivot table which has Rows = Product Code,
Columns = Year&Month, and Data = Total Sales. This graph isn't particularly
usefull to my sales guys as it doesn't really show how a ...

The instructions in "help" for establishing a trend line [best fit] are
1.  Go to Chart Menu
2.  Insert "add trendline"
The only chart Menu that I can find is under "insert", however, I can

How do you get a line graph to pick up and show dates as the values on the x
axis, not starting at zero nor at the first of the month. There doesn't seem
to be anywhere for x-axis data to be transferred to the x- axis. I did put
the dates into a row of cells and highlight them. i ...

I want to plot a chart but only show data labels for the values which are
greater than zero.  I cannot find a way to remove the zero values and have a
chart which has a large amount of worthless data labels.  How can
automatically remove them?

PIVOT TABLE
Create a pivot table showing the highest and lowest total in ‘94 by
territory..
I have a worksheet set up by east south central west territories. I