Thank you very much for your excellent and detailed answer, Shane, I
appreciate it!

--

igor


"ShaneDevenshire" wrote:

Hi Igor,

This is a standard Excel problem - You will need to trick Excel into
plotting columns on two axises.

Suppose your data is in cells A1:C10, I'm assuming categories in column A
and your two sets of data in B and C with titles on the first row:

1. Select column letters B:C and choose Insert, Column
2. For ease enter a title in cell B1 and C1 and enter values in B2 and C2
which are about the same as your real data (we will remove them later)
3. Plot your column chart using this entire range A1:E10
4. Select the 3rd series on your chart (just one bar) and choose Format,
Selected Data Series, Axis tab, Secondary
5. Select the 4th series and press F4 (this repeats the command in step 4 on
the 4th series)
6. Click the Legend once, then click one of the two dummy series titles and
press Del (make sure you are selecting the series name and not just the color)
7. Repeat step 6 for the second dummy series
8. Delete the data from cells B1:C2

--
Thanks,
Shane Devenshire


"Igor" wrote:

Hello,

I have the following problem:

I have 2 series which I need to represent with a column chart, using a
primary and seconday Y-Axis. In each period in the X-Axis I need to have 2
columns, one next to the other. But what I'm getting is 2 columns, one in
front of the other.

I have tried to solve this by formatting the data series, without positive
results.

Can anyone, please, help me?

(I'm using Excel 2003.)


--

igor