Hmm... I tried that and every time I have Excel crashes.

File Version : 11.0.6555.0
File Description : Microsoft Application Error Reporting (DW20.EXE)
File Path : C:\Program Files\Common Files\Microsoft Shared\DW\DW20.EXE
Process ID : 0xB78 (Heximal) 2936 (Decimal)

Binary dump of the packet:
0000: 00 13 10 D0 DF 26 00 13 : D3 29 8C AB 08 00 45 00 | .....&...)....E.
0010: 00 30 71 E7 40 00 80 06 : D0 4C C0 A8 01 64 83 6B |
0020: 73 1C 06 9D 00 50 38 C0 : 99 2B 00 00 00 00 70 02 | s....P8..+....p.
0030: FF FF F1 B2 00 00 02 04 : 05 B4 01 01 04 02 69 6C | ..............il


"Andy Pope" wrote in message
...
Select it and then via the menu Chart Chart Type.

You can use the cursor keys to cycle through the chart elements if the
data series is not easy to click with the mouse.

Jeff wrote:
How do I change just those series to a stack bar/column chart?


"Andy Pope" wrote in message
...

Hi,

Add 2 data series. Change both new series to stack bar chart.
The first of these new series should have a value equal to the lowest
value. The 2nd should have a value equal to the width of the shaded area.
In order to complete the chart you will need to,
Format the 1st series to have no fill or border.
Format the 2nd series to have no border, Yellow fill, Series Options Gap
Width of zero.
Format secondary x axis to have the same min and max scale values as the
primary x axis.

Cheers
Andy




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info