Is there some way to specify conditions under which data
points should be excluded in a chart?  In particular, I
have two columns for which I want to create a scatter
plot.  However, some of the rows are missing data for one

Can anyone tell me how to change data in the primary axis
so it displays in the secondary axis, for example, cost of
mobile phones from £30 to £400 displayed alomg the primary
axis. At present it keeps being displayed along the

I am trying to x-y plot a data set.
at times I have zeros where no data is needed in a standardized format.
I don't what to show these zeros when I print the worksheet so I used
something like a1: if(z10=0,"",z10)

I get the above message while I'm working with my excel
2002 file.  It's a big file with lots of charts.  When I
copy and paste a chart I get the above message and the
program locks (although I can usually save and re-open).

Hope someone can tell me how to do this....
I have one set of points which form a straight line -
these are (3.1,0), (3.1,100), (3.1,200), (3.1,300) i.e. a
vertical line.

I have a chart that has blank info in the legend.  I want
to add an * to indicate something, but just inserting a
symbol doesn't work.  Any ideas?  Thanks.

How do we create a gradient for a straight line and at the
same time calculate the value of the gradient?

I use Excel 2000.
I have a macro that creates a chart. I assigned this macro to a
autoshape. When I am done looking at the chart I have to delete it
Isn't there a way to make things in such a way that I could just toggl

I am very new to EXCEL, please refer to the macro and help
if you can.
My question is I got an error message "unable to get the
chartobjects property of the worksheet class" at the codes

Is it possible to directly edit the size of the box the chart title appears in an Excel 97 chart? For instance, click and drag the size of the title box the way I would the total size of the chart
tj

Both machines are running the same version of Excel.  Yet,

off

Is there a  trick to exporting charts to Adobe Illustrator 10.0?  I have no problem simply copying and pasting them into Photoshop, but Illustrator, though it seems to recognize an object on the clipboard, does not respond to the "paste" command.  Is is neccessary to save the ...

Hi VBA Pros,
I have dozens of 36 similiar bar charts. I created one chart and
copy-paste it to get the other 35 charts. Then I linked each to
different data source to get my report. But my problem is that the

HI, I am new to this site and have tried to find my specific problem and
have not been able too.
I have an excel spreadsheet, that was previously created by others (no
longer working here) We have been able to use the data and get the

I can't change the following date to a different Number
format. [Format Cells>Number...] How could I change it to
like, 12/26/00 or 36886?
26-Dec-2000