I think I've tried this a million times now, and clearing the vertical lines also clears the lines on the floor (and i really want them to be black on the floor to show the grid).
Could there be some settings that allow you to better manipulate the chart? or maybe a different version of excel? - I'm using 2003.
I'm using 2003 as well, the only other thing I can come up with is a bit of a workaround fiddle. If you drawing a rectangle from the Drawing Toolbar and format that with no border and a white fill and carefully place over each vertical line.
It gets the result you want but, probably not what you really want to do though?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Haha, I just tried that same thing yesterday. But, no it doesn't really work because I've written a macro to make the chart based on data with varying size grids. So I haven't really wanted to take the time to figure out some sort of algorithm for sizing the rectangles each time.
Thanks again for your help though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks