I am making a chart using data from a worksheet that
includes only weekday dates, however, when I make the
chart using that source material, Excel automatically
adds in weekend dates. I do not want the weekends to be

I'm trying to create a stacked column chart that contains
many stacked elements.  Y-axis is Volume, X-axis is time
(say, month), and the stacked elements are different
products contributing to the overall volume for the

Does anyone know how to make paired bar charts in Excel.  For example I
would like to show sales for a particular product with the
corresponding profit under (or left/right).  Is there an easy way to do
this?

I'm trying to crate a chart where to information in the cells can be typed on a slant

I am new to making charts with Excel. I want to create a comparative. This chart is to show 2 different groups of values on the same chart for comparason.
Thanks for the help.

I am attempting to link a cell from my spread sheet to a
text box in my chart, but have been unable to do so.  Does
anyone know how or if this is possible.

Is there a way to keep Excel from plotting a trendline the
same as using #N/A to keep it from plotting series points?

Help...
Is is possible to insert a header and/or footer into
multiple charts(Excel 2000 or 2002)?   I was hoping I
could insert a common chart header/footer as is possible

Anyone know how to add another y-axis to a simple area chart?
Thanks a bunch!
Jack
------------------------------------------------

On a single series, is there a way to put multiple
trendlines on a series?  Example:  say data from January
throuth June are a positive slope, then from July through
December the slope is negative.  Can I have separate

"How do I change the format of a data series in a chart from a line to a column?"

I am presently trying to develop a bell graphic to display
statistical values, but I can't figure out how to get the
graphs to show the curve, Do I need special programing or
add-in?

I have created a chart using data from C2:AR2, which works Ok
Now what I want to do is to add a line across the width of the chart which
shows the average of C2:AR2, so that I can immediately see which elements
are above average and which are below.

Im using the WorksheetFunction.Substitute code to change a series formula. But when a series sources data which is #NA, the code wont work, as the data is not visible on the chart. Anyway around this to change those series also?
many thanks ahead

  I have created some Pivot charts in MS Excel 2000 with
page level fields. But my customer uses Excel97 and he is
not able to see the Page level fields and cannot see
different views of data. It seems that Pivot charts were