"Make a second value axis".  I don't get an expected choice in the Format
menu.  Help tells me to use "Selected data series" on the "Format" menu.  It
is not there.  Is it just me?
Baffled.

I have a problem that I can reproduce on Excel 2000 and Excel 2003 (but not
in Excel 2007). Excel crashes when I try to re-position a chart in a
worksheet with (at least) a cell using data validation.
If I select a cell with Data->Validation a little triangle appears close to

When displaying a data table for a single set of data, how do I remove the
label saying 'Series 1' which appears?
Hopefully, thanks!

want to construct a stacked bar graph with each bar representing a specific
variable and the components of it.

I am using Offset formulas in Excel to create dynamic ranges and then
plotting a graph of those ranges. At times these dynamic ranges do not return
any results and that time i get following error message:-
A formula in this worksheet contains one or more invalid references.

I have a bar chart that is updated on a regualr basis.  My problem is that
when the bar goes negative, I can't get the bar color to go red, as I could
in previous Excel versions.  Is there something I'm missing in the formating
window?  I've tried the invert if negative but that ...

I would like the color of my data points to vary based not on their x or y
value, but rather on a third column running alongside them.  How can I do it?

Hi everyone! sorry if i am lagging a little here but I still have the excel
2003. my issue is that I have a block chart. I have a green background and a
yellow block showing my data. What I was wanting to do is to make my yellow
block a little transparent so that it can show a ...

Bring 'shorter' series to front?

SELCT. accessed by: activ.chart...[from just activated menu tabs] format ...
arrange > selection pane.  Dialog pane opens ... but, how to go from there? -
Boswell

Hi -- does anyone know if it's possible to have more than one secondary chart
in a bar of pie or pie of pie chart? For example, if I have a main pie
divided into two wedges--one showing the total number of cars and one showing
the total number of trucks--and I wanted to have a ...

I am using VBA in Excel 2003 to create charts using columns of data on a
spreadsheet as the chart source.
I have a dataset of numbers that range in the hundreds, but occasionally
 one of the data points is zero. When I plot my data, the zero values

The following formula works great:
=SUMPRODUCT(--('Filled Reqs'!$R$2:$R$389>=("08/01/07"+0)),--('Filled
Reqs'!$R$2:$R$389<("09/01/07"+0)),--('Filled Reqs'!$B$2:$B$389="am
compliance"),--('Filled Reqs'!$I$2:$I$389="NC"))

I am creating a series of column charts, and I would like to move all the
data labels in a series to the top of the chart (above the column and evenly
spaced)
The VBA code to do so for any individual point in the series is:

I've generated two sets of biomechanical data for a medical research study
(one set is in Newtons, the other in Newton-meters).  So, for each given
experimental model, I have two kinds of data.  I'd like to put the results
from the two experiments side-by-side on the same bar ...