Excel Charts

[jomijomi998]

Does anyone know why I'm having problems selecting 'series'. I have four
catogories on my chart, with this particular series being a different type.
I want to select this series to change to match the other 3 series, but I can
not for the life of me get to that option. Has anyone else ever encountered
this problem. I remember once getting around this problem by temporarily
adjusting the data to a very large number, but that's not even working now,
and I'm sure that's not how it should be done. Any advice would be welcomed.

 

[Andy Pope]

Hi,

How about using the cursor keys to select items.
http://www.andypope.info/tips/tip003.htm

If the series has no data it will not be displayed and can not be selected.

Another option maybe to use the selector which appears on the Chart Toolbar.

Cheers
Andy