change invisible bars back to visible
 

Various special charts (floating bars etc.) make use of invisible bars
(bars without border and with no area color). How can I access such
bars to change them back into visible ones? I can have them marked by
clicking on an adjacent bar and using arrow keys to locate the next
item(s), but the mouse cursor only catches the underlying chart area
and I cannot find a key combination to bring up the context dependent
menu nor the "format data series/points" box once the bar is marked. I
have MS Office Excel 2003.

change invisible bars back to visible
 

Select the hidden series using the Chart toolbar's Select Chart Object
dropdown.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"hf" wrote in message
oups.com...
Various special charts (floating bars etc.) make use of invisible bars
(bars without border and with no area color). How can I access such
bars to change them back into visible ones? I can have them marked by
clicking on an adjacent bar and using arrow keys to locate the next
item(s), but the mouse cursor only catches the underlying chart area
and I cannot find a key combination to bring up the context dependent
menu nor the "format data series/points" box once the bar is marked. I
have MS Office Excel 2003.