Thread: 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.

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" <hakon.finne@sintef.no> wrote in message
news:1154090384.054629.247270@m73g2000cwd.googlegroups.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.
>