Excel Charts
 

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.

Excel Charts
 

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

jomijomi998 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info