I am running Excel2000.  I wish to create a chart that does not seem t
be supported in Excel.  The data consists of a table of dates an
?states? (let?s call them A, B, C, D and E).  One column is dates an
the next is states.  Dates will be in order.  A given date could hav

The user has asked that the darkest colors and specific symbols be used for
readability of the chart:
Black is the most preferred color; white is the least-preferred.
Symbols to have lowest priority for use are "-" and "--" (double-wide line).

With reference to the following webpage:
http://www.trentweirproject.co.uk/archgraph.html
The chart shows the level of the river (blue line) along with the
optimum river level (horizontal lines) needed for various locations

I work with Excel a lot and I often get request to "Bold 1 or 2 lables on the Category Axis" of a graph...I'm unable to
customize a formula, so I just ended up floating the Bolded Text which I despised. IS THERE A TO DO THIS WITHOUT FLOATING THE TEXT
Thank You

I have a bubble chart that plots 7 business opportunities
as follows:
a) Attractivenes on the Y axis (10 lowest, 100 highest)
b) Probability of success as a % on the X axis(10 lowest,

Some time ago, I asked about two y axes on a chart, the left of which showed
whole numbers from 0 to 16 and the right of which showed whole numbers from
0 to 55. I wanted to hide the only number above 12 on the left axis (16) and
hide all numbers below 40 on the right axis (0-35).

I have a excell file that do not have columns A and B,
I fail to unhide the two columns.  when I print or preview
the file, I can see the columns A and B.  Why?
How can I edit the two columns?

I am trying to set my graph range to be variable, however, I kee
getting the error message at the ###############  "Run time erro
"1004""
Is it simply the format of the text or is the code wrong?

I am trying to create a basic bar chart to include 3 seperate cells of information
employee name                year              salar
I have been successful in getting the employees names in the Legend corresponding to the color coded bar, the year on the left hand side of the ...

Excel 97.
Can anyone spot where I'm going wrong? I'm trying to
change the source data in code so it only shows upto the
last cell that has a value in it. My code at the mo is..

I have a spreadsheet where I enter time line data in the
cells and from that information generate a Gantt chart.
What I would like is a way to have symbols on my chart to
show milestones, and end points. Anybody have any ideas as

In a frequency histogram the area represented by the bars in the chart is area proportional, if after the histogram is created it is converted to a radar chart are the shaded petals(areas) that are created still area proportional as in the histogram?

How is it possible to select a data range by using variables?
i.e. instead of range(A:1,c:3) have range(i,j)
Here is my code, the line with the '#####  raises an error:
"Invalid or unqualified reference"

I am using Excel 2000.  And, I need to count cells that
fall in multiple criteria.  For example, I have 5 numbers
93.84, 100, 95, 92.5, and 92.5 in cells from A6 to A10.  I
wrote the following formula to count the number of the

i have x values and y values in columns and i add more values everyday
I want to have a XY scatter chart which only shows the last 25
entries. Therefore I'm trying to do something like this:
cell E1 contains the number of the most recent entry eg 350