Is there a way to have a clustered column chart that has stacked columns?
Thanks

I am plotting temperature data in a x-y scatter plot in Fahrenheit and am
using a dummy series to have a corresponding secondary axis in Celsius.  I
would like the range of the secondary axis to change automatically when the
primary Minimumscale and/or Maximumscale values are ...

When selecting a chart, format, chart options I receive the message No more
new fonts may be applied to this workbook!!

I have 5 series of data, one is different from the first four.  I create them
all in a column chart then edit the one different series to be a combination
line on the column chart with a secondary axis.  When I do that I lose one
whole data series of the 4 similar ones.  It is ...

I've tried changing the Chart Type on one of the data series to a Line graph.
The data shows as a Series in the Legend, but not in the Chart Area.

I'd like to display just two gridlines on a bar chart where the values range
from 0 to 100.  The problem is, the gridlines that I'd like to display are
at 20 and 90.  I can't seem to select and change the colors of individual
gridlines through the Excel interface or through VBA (not ...

I am building a set of templates to automate building charts and reporting
information.  Is there a way to keep Excel charts from displaying a zero
value for future information, i.e. actual usage in March 2005, while
retaining the appropriate cell reference?

I have a data series to chart, say A1..A20.  As I input new data I insert a
cell in A1 and enter the data.  However on my chart source data it changes to
a new series of source data to B1..B21 when I insert "Shift Down" the cells
and insert new data.  I want the data series to ...

How do I flip a column of numbers, to reverse the order.

I have used Excel in the past to create GIF files of charts to be uploaded to
the Web through Dreamweaver without difficulty.  Using Excel 2003, however,
GIF files that I create by "saving as web page" turn out fuzzy when posted to
the web.  (They look fine when copied to Word or ...

I want to add a simple horizontal line across a chart that represents the
average of the lines of plotted data, in my case monthly grocery
expenditures. The data is graphed in a simple bar format, and I'd just like
an average line that stands out.

I have a cell with this formula:
{=INDEX(B:B,MAX((B1:B368<>0)*ROW(INDIRECT("1:368"))))/(316+COUNTIF(D3:D368,"

I don't remember how it was made up (I got help on this forum), but now I

I have stock data. Row 35 is the nearest day. Row 36 is the next day, etc.
When I chart the data using a 2 axes chart (custom), the chart doesn't
display backwards. The nearest day displays on the left side of the chart,
not the right. How do I change that?