On Aug 11, 11:43 am, Del Cotter wrote:
On Thu, 9 Aug 2007, in microsoft.public.excel.charting,
Chris S said:

I am currently trying to chart two series:
problem is one series is a category series and the other is a value
series.
and if i put one series on the primary x-axis and the other on the
secondary x-axis, they do superimpose (which is what I am trying to
do), but the scales of the 2 x-axis is completely different (because
one is a category and the other a value axis).

What's your actual problem? As with so many classes of problems, there
may be more than one solution, but which of the solutions is best
depends on the precise nature of what you're trying to do.

If you have only one chart to do, then right-click on the Value x-axis,
select Format Axis.. Scale, then set the Minimum and Maximum to some
appropriate value that matches the bins.

Taking Mike's picture inhttp://www.treeplan.com/better.htmas an
example, if your bins are 0-5, 5-10, and so on until 45-50, then set the
value axis with minimum of 0 and maximum of 50. Take care that the bins
in your histogram actually all have equal width for this purpose-- in
this example they're all 5 units in width-- and your statistical
aggregate measures should line up nicely.

If you now say you have 900 charts to do and can't take time to do them
all manually, well, all I can say is that wasn't described in your
original question.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Thanks Del, but unfortunately my problem is the latter: many many
charts (i.e. I cannot manully change the scales, and therein lies my
problem). Any ideas?