I have three columns of data as follows:
Name Value1  Value2
a           1          2
b           3          4

I'm trying to plot a lot of data with gaps in the columns (empty cells) and
would like to be able to plot the series with points omitted if either x or y
are zero.  It seems that Excel, rather than assume that a blank cell is zero,
stops plotting there... Can anyone help me with ...

I am fairly new at this so sorry if this is an obvious answer.
I have created a spreadsheet with the following columns:  Payee, Date and
Amount Paid.  It is simple, functional and working fine.
I want to be able to create a chart so that i can easily view the amount

I am doing a project for Chemistry. I need to know how to put two graphs on
one axis, and how to create the "bars and whiskers" used to show error.
Thanks for your help.

We should be able to time scale the X axis in PivotChart Reports. Pivot
Charts are very usefull. I don't see any good reason to lose the time scale
propety while doing a PivotChart Report.

Hi All......
I have a Line Chart wherein all cells in my source data that are blank, ( as
result of a formula resulting in ""), all plot as ZERO, and I would like them
to just be nothing, not charted.......I do not want them interpolated and the

I would like to create a bar chart with the information below.  I would like
the lost and sold to be shown on one bar stacked for each year.  So I would
have 3 bars for Jan - 2003, 2004 and 2005 each bar showing two colors.
Any help would be appreciated.

I need to custom format my Y axis the only on the top number of the scale to
appear with the $ sign and the rest of the numbers #,###. Thanks

I am doing a graph of start and stop times for a process and having some
trouble with the data.
I am using a stacked bar with 3-d visual effect and have days on the y axis
and times on the z axis (i would call it the x, but excel seems to use z)

How do I keep a chart from plotting blank cells that have a formula in them?
i.e. =IF(ISERROR(D2/D3),"",D2/D3)

I would like to chart three series.  I would like two
columns in each group.  The first column in a group would
be series 1.  The second column in a group would be
series 2 and 3 stacked on each other. Is that possible?  

I am trying to plot three parameters on a single XY line chart. Is it
possible io have three different scales charted to cover all the three
parameters which are quite variable numerically? Using Excel 2000

I am trying to show several pieces of data on one chart but do not want the
plot lines to overlap rather to extend out each on its own plot area with
lines seperating each plot area.  Any ideas?

I'm making a chart with two values for class.  One of the values is very
small (3) and the other is very large (317).  How can I make the axis values
"break" so to speak, so that the difference between them is minimalized.  For
example, I need a portion that goes from 1-7 and ...

I do have approx 50 charts (with multiple series) in 1 workbook (excel
97) which show monthly data. I would like to update the chart data
range to show always to the last 12 months of data by running once a
month a macro.