Im working on a spreadsheet and I want to be able to type in all the numbers
and then have a formula to get rid of duplicate numbers

Hi all,  I have to plot 4 series in an excel chat but the values between
series are too diferent to see it well.
Does anybody know how to plot it in a chart in some kind of multiscale Y-axe?
My values are

I am looking for a way to manage data labels in an automated charting
procedure I am writing.
The chart is a waterfall chart (I believe) and I'd like to be able to loop
through each dataseries/column to find the height of the total column and

If I am trying to chart a single row of data appearing in 600 columns, is
this data in 600 data points, which is chartable, or is it 600 series, which
is not chartable?  I have divided the data between three worksheets due to
worksheet limitations of 256 columns, but I have not ...

Is there a way to use the current filename as "Chart Title" in the "Chart
Options" of a graph ?

I am trying to create a graph with a variety of Series of Data. I am able to
select a cell for the Series Name. The problem is that the Chart's font
formatting overrides the formatting that I have assigned in the cell.
My desire is to put some sort of name such as ABCDEF with the ...

I have lot of charts (44 in total) in one sheet. The data for the charts are
linked to another spreadsheet. When I update the values the charts are not
updated even though both files are open at the same time. It will only update
if I manually re-visit the data ranges or close ...

Hi
I have one sheet. It contains some charts. I want to put th
XValues use macro. But I am unable to run this macro. I got error a
Unable to set the XValues property of the Series class.("Run time erro

i need to plot a data which has about 1000 lines in excel xy scatter chart.
please help me

I changed the colours on the data series on my pivot chart but when I
refreshed the data it switched the colours back to the defaults. How can I
stop this?

I have a big Excel doc with numerous charts, each with numerous lines.
About once per month, I need to extend the charts for about a month. This is
a very painful process for each graph (multiplied by numerous graphs!).
Does anyone have any simple method to do a mass change, ...

I've been looking for a way to conditional format a graph. I want a few items
to be a different color than the rest from the same set of data.
Been having to manually change each data point color (6 or 7 of 50 items),
just looking to see if i can automate it.

can someone tell me asap how i can calculate half lives for a curve in
microsoft excel?

Is it possible to get Excel to compress a part of an axis, while let
the other part have the axis expanded.
I.e:
y value 1 to 100 with a tick of 10, while value 100 to 1000 a tick of

Please add the ability to label points in an XY graph. This feature was
available in the very first release of Lotus 123 in used back in 1984. The
add in "XY lChart abeler" works okay, but is very slow with large data sets
and does not work well when the data is modified (e.g. it ...