I want to make my #NA values invisible in a table, from which a chart is
produced. I have to use NA(), not "", or else the chart doesn't plot
correctly. The error values are produced (when a referenced cell is blank)
by a formula of the form: =IF(B40="",NA(),24*60*(B40-$C$14))

I am trying to create a very simple column chart in Excel
2002; the source data looks like this:
ColA   ColB
Red       4

That would work but here is my senario, which I should
have stated in the first email:
  A        B        C        D         E         F
Product     Def 1   Def 2    Def 3     Def 4     Total

I dynamically produce my chart and the SeriesCollection.Values
property is populated as an array (as opposed to a range).  It has to
be an array because the values are calculated.
It all worked well for a number of weeks but now I get an error when

Does anyone know how to make a chart appear in asending or
desending order using VBA code? I have set up a simple bar
chart and would like the bar chart to have the highest
value and bar begin at the left and, as the number

Does anyone know how to change the label/value source of a
series. I have problem using a different data as a
label/value source. Currently I only get the X axis (Date)
or numbers but I need a text that changes with every point

those microsoft muppets have included that trendline function which is
great.. but does anyone know how to customise your own trendling
function??
All I want to do at this stage is what many people I imagine might

I have the following data:
3
6
11

when I make a chart, the horizontal axis is always longer
in length than the vertical axis. this is inaccurate when
I have the same number of scale points (say 10) for each
axis. the chart should look like a box or square, not a

I want to plot data on a 2-cycle semilog X-axis with a Y-
axis scale defined by me, the user.  i.e., major Y-axis
divisions would be 1/2 inches apart when printed.  The
output graph is to be used with an overlay to detect

I have created a 24 point radar graph.  I need to figure
out how to graph just 4 points only on the graph,
without "changing the shape" of the graph.  Basically the
graph is round (with 24 points) I want to graph just 4

When cells with formula like ="", cells return empty value
(blank cells).  However, if trying to plot these cells,
the plot will show zeros versus row numbers.  Anyone knows
how to fix the problem?

I have 2 columns of data for an x,y scatter chart in Excel
2000. Another column on the left contains the labels that I
want to show up next to the points on the graphs. However,
when I add data labels or values, the chart only shows the

I use a spreadsheet file (excell 2002 sp2) in which I have
about 30 charts displaying data taken from the same sheet
different tab.
This has worked fine for several years but all of a

Is there a way to format cells so that when you type in a
whole number, it is converted to a decimal?
(EX:  If I type in 150, I want the cell to format this
whole number as .150)