Please advise on how to graph one line data series in different color
without changing the colors to each data point.  Thanks.
-----------------------------------------------
~~

A while back I had copied a sample dynamic chart that both
zoomed and scaled and dynamically selected data to
display. Since then I had to reimage my PC and I lost that
sample chart.

Hi all. I have a line chart, for the sake of simplicity, lets say th
line chart depicts the garph of y = x. What I need to do now is displa
a particular point on this line, lets says (2,2). How can I add thi
point so that I lies on the line chart? Also, what I would like to d

In a shared folder I have many .xls files.  On some the chart icon i
grayed out.On others it works normally. None of the help screens ha
helped
-----------------------------------------------

I would like to develop an organizational chart for our
business and understand that Excel has that capability.  
But, I am unable to find it in my Office 2000 product.  Am
I missing it or is there other software that I need to

i have an ever growing column - earliest at top, growing on bottom -
how can i pick off the "last" n positions to chart
thanks
mike

I have a simple formula to calculate the min/max scale on our control
charts. I tried to link the cells with the min/max values  to the Min/max
areas on the "Format Axis" form.
It didn't work with a "=" sign or a direct link.

Hi All,
I have a summary page and I want to create a chart using
that data.  My only problem is that I have a percentage
field 15.675 that imported in a custom format of "0.000_-

how I transfer a spreadsheet to the pocket pc?

How do I format a category axis so that I can properly display chemical formulas?  (like H2O, the 2 needs to be a subscript, but the rest of the letters need to be normal text?  I can format the whole thing as sub or superscript, but that's not what I want to do.

Has anyone else tried writing a zoom feature for Excel
charts? (i.e., dynamically zoom in/out to an Excel chart).
I've just finished writing one ... seems to work well for
all charts (unless they're 3D):  wondered whether there

Hi,
I am putting together a bar chart and thought it would be a nice touc
to change the colour of the gridlines to represent threshold markings
ie. 10 - 50 = green ; 60 - 80 = Amber ; 80 and above would be red.

I have several charts on every Excel Worksheet. I'd like to program VB
to select them. In order to do so, I need to know the 'name' of eac
chart.
How to display it quickly?

I have created a scatter graph showing the results of 200+ pupils in two
tests. The x axis shows the result of test A, the v axis test B.
My problem is that some of the points on the graph represent 1 pupil and
another may represent 70. Please can someone tell me how I can indicate ...

I am trying to add additional series to a stacked bar
chart with a secondary y-axis; however, each time that I
add the new series information, the new (added) series
appears behind the old series and therefore is not