Windson:
Sorry to be late with my answer - I was on vacation.
I believe this desire can be fulfilled, yes.
In the table you can simply use conditional formatting, to give the cell an
outstanding colour, a bold border or any formatting effect you want to apply.
Simply select from the menu Format/Conditional Formatting...
In the graph: create two new data series from yr original data set, both
with IF statements with complementary conditions. Example: say you want to
highlight values >100. Yr original data series in A, set up the two series
in B and C. B as IF(A>100,A,NA()) and C IF(A<=100,NA(),A). Don't plot A (I
assume XY scatter chart), but B and C instead. The NA() values are ignored,
and the two series complement each other. If u hv only one value >100, this
will appear as different colour. You can change the marker. Of course this
principle can be adopted to other ways (e.g., a circle around an data point t
highlight, or an arrow pointing to a particular point.)
HTH,
Henk
> HEK:
>
[quoted text clipped - 25 lines]
> > >
> > > Thanks for any hints there.
Windson - 01 Sep 2006 04:29 GMT
Henk,
Thanks for the idea. I tried similar ways before. The only problem is you
have to use different series (or columns) of source data. So if you have ten
differnet groups to highlight in distinctive ways it's a little
time-consuming. What I am seeking for is a more automatic way using a single
column as Y values. Probably I need macro to do so, but I am not good at it
now.
Thanks again and hope you enjoy your vacation.
Windson
> Windson:
> Sorry to be late with my answer - I was on vacation.
[quoted text clipped - 45 lines]
> > > >
> > > > Thanks for any hints there.