I followed the directions for creating a stacked-clustered chart, but I lost
the lines that I also had on the chart.  Is there a way to represent data as
a line in a stacked-clustered chart?

I have three years' worth of sales data, by transaction.
Example:
1/2/2002    5
1/2/2002    2

I have a completed graph that shows side by side columns and a line, but I
would like to add a stacked column to the graph without losing the other side
by side columns.

I have several rows of data that are separated by several other rows (that I
don't want to chart).  Is there a way to chart several rows of data on one
continuous axis?  For example (see below) I want to chart Row 1, Row 3 and
Row 5 on one axis that would show a trend of 25, 50, ...

I'm using Windows 2000 and Excel 97. During X'mas I started learning
charting - J. Walkenbach's Excel Charts (2003). Got stuck after Chapter 2,
after I had entered the user-defined data (parameters) and save them in the
xlusrgal.xls file. When doing Chapter 3 exercise (plotting ...

I am unable to display data tables in Excel 2002 charts, because the "Data
Table" tab does not appear under the "Chart Options" menu as in does in
Office 97, and as the help file says that it should. Any suggestions?

Despite being able to graph data on a secondary axis in Microsoft Excel X, I
have been unable to format said axis (ie make it start from a value other
than zero).  No amount of trying to click on and select the axis or the
values has helped.

Is there a way to add a second X axis at the top of a chart?  I want to plot
a normal distribution curve with the base on the Y axis (versus the usual X
axis) and use the second X axis at the top of the chart as it’s value (Y)
axis.  The X axis at the bottom of the chart is ...

I am trying to make a cell value be null with the
following:=IF($C$2>=A18,A18,"")
My goal is to make C18 be empty if this is false.  I don't want it to be
blank; I want it to be as if I never typed a value in the cell at all.

Is it possible to have two Y Axes (one left and one right) with only one data
series?
Thanks,
Phil

If I have a chart that its data source refers to a range, how to get a lot of
charts that refer to different cells and display different values? just like
dragging and dropping cell to get many cells that contain auto-increased
formula.

How can I use bar graphs for three different products with two axes becuase
of two different sets of info for each product and get the graphs to stop
plotting on top of each other? Please help!!

I am dynamically populating multiple Horizontal Bar Charts with Data. I
want the Labels (y axes) and chart area (Bar Charts) to be the same on
each chart.  When I dynamically set the data the labels and charts
resize themselves based on the width of the data.

I am trouble-shooting for an internal client. When he has zero values in a
log chart, he gets the following message:
"Negative or zero values cannot be plotted correctly on log charts. Only
positive values can be interpreted on a logarithmic scale. To correct the

We are trying to have the "negative" numbers in a data table (under the
chart) show in red, like the data series, but seem unable to alter the format
unless it is for all data.  (we're trying to highlight or bring attention to
the negative variances)  The data labels will follow ...