If a formula is in the cell but is blank or equals "0", how do you get a
chart not to plot until a number appears?

I work from home and in sales i need to keep a record of my telephone
conversations, i have outlook which i use but want a excell spreadsheet which
i can see all my calls at once.

I have created a chart that has the following data:
50
45
35

In a workbook it is possible to find and replace data in cells and formulas.
Is it possible in any way to find & replace data in series in a chart object?
In have charts with more than 100 series on each chart and I would like to
be able to change all series on a chart using an ...

Is there a way of attaching  data labels from a text range to data markers in
xy plot chart. I'm sure I could do it in Lotus 123

Hi,
I've created a Scatter Chart in OWC11 in C# and the X axis must display
dates instead of numbers, I do it using the code below:
...

I plotted a weight vs time graph but to linearize the data I used the  
inverse of the square root of time to create a chart.  Is there any way I can
make the x-axis labels represent the actual time values while still having
the scale of the inverse sqrt?  I want it to label the x ...

Hi all,
I'm having a problem when I want to publish an Excel chart to Web
page. I browsed through the Microsoft Knowledge Base, and found the
article describing the Post SP3 hotfix that sghould be deployed in

I am trying to create two side by side bar charts that have the same y-axis.  
I would like to have one chart with the x-axis increasing from right to left
(this would be the chart on the left) and the other chart with the x-axis
increasing from left to right (this would be the ...

I´m trying to create a chart that apears like a speedometer to use in a
control panel. I want to create a Project Control Panel and the chart will
display the value like a speedometer or barometer. Thanks

I wanna change the color of single points in a 3d surface chart according to
a seperate value for each point (i.e. date, time, price chart with the
surface color representing the volume). I figured it out for 3d column charts
using the sereiesCollection(i).points method  but ...

I have two identical tables side by side and I'm trying to use one line of
code to work for both tables.  How do I write a variable range?
My code is as follows:
   If intColumns = 0 Then

I can't figure out how to change the gray letters on the top of a worksheet
to months. I could write them in cell #1, but then my dates would be off
since I am using the numbers on the left hand colum as dates.
Can ya help?

Ok so this is a really weird one.
To download the file discussed in the message below, pls visit the following
URL:
ftp://eff.csuchico.edu/downloads/BAD/HighDemog.xls

I've got about 40-50 points in a scatter plot all with lables that are about
5 characters long.  Many of these labels overlap with each other and with
other data points.  
Is there a way to automatically move the labels that are overlapping?  I can