vertical gridlines in 007
 

Has anyone tried to format a vertical gridline in 007?

Everytime I try it, the horizontal gridlines are formatted instead.

And I can't select the veretical lines with the mouse (I have to use
the layout format selection).

And when I delete the horizontal lines (I thought that might help) the
vertical lines do not appear
on the format selection -- but the horizontal ones still do.


(I'm sorry if this has come up before, but I had to switch to a new
newsgroup reader)

Gary Klass

vertical gridlines in 007
 

Works for me. I can select with the mouse or with the dropdown, and I used
Ctrl+1 to open the Format dialog. I could also format the lines using the
Chart Tools/Format tab.

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


"Gklass" wrote in message
ups.com...
Has anyone tried to format a vertical gridline in 007?

Everytime I try it, the horizontal gridlines are formatted instead.

And I can't select the veretical lines with the mouse (I have to use
the layout format selection).

And when I delete the horizontal lines (I thought that might help) the
vertical lines do not appear
on the format selection -- but the horizontal ones still do.


(I'm sorry if this has come up before, but I had to switch to a new
newsgroup reader)

Gary Klass

vertical gridlines in 007
 

It happened on a stacked area chart -- not on other types
with a lot of data (3k).


On Feb 7, 4:12 pm, "Jon Peltier"
wrote:
Works for me. I can select with the mouse or with the dropdown, and I used
Ctrl+1 to open the Format dialog. I could also format the lines using the
Chart Tools/Format tab.

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

"Gklass" wrote in message

ups.com...

Has anyone tried to format a vertical gridline in 007?

Everytime I try it, the horizontal gridlines are formatted instead.

And I can't select the veretical lines with the mouse (I have to use
the layout format selection).

And when I delete the horizontal lines (I thought that might help) the
vertical lines do not appear
on the format selection -- but the horizontal ones still do.

(I'm sorry if this has come up before, but I had to switch to a new
newsgroup reader)

Gary Klass

vertical gridlines in 007
 

Stacked area chart, two series, 3000 points. It still works as I'd expect,
though it's slower than I'd expect with 3000 points.

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


"Gklass" wrote in message
ups.com...
It happened on a stacked area chart -- not on other types
with a lot of data (3k).


On Feb 7, 4:12 pm, "Jon Peltier"
wrote:
Works for me. I can select with the mouse or with the dropdown, and I
used
Ctrl+1 to open the Format dialog. I could also format the lines using the
Chart Tools/Format tab.

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

"Gklass" wrote in message

ups.com...

Has anyone tried to format a vertical gridline in 007?

Everytime I try it, the horizontal gridlines are formatted instead.

And I can't select the veretical lines with the mouse (I have to use
the layout format selection).

And when I delete the horizontal lines (I thought that might help) the
vertical lines do not appear
on the format selection -- but the horizontal ones still do.

(I'm sorry if this has come up before, but I had to switch to a new
newsgroup reader)

Gary Klass