+ Reply to Thread
Results 1 to 9 of 9

Removing Gridlines from 3D Column Chart Walls

  1. #1
    Registered User
    Join Date
    07-24-2007
    Posts
    15

    Removing Gridlines from 3D Column Chart Walls

    I am wondering if there is a way to remove the Category Axis and Series Axis gridlines from the walls of a 3-D Column Chart. Naturally, I can easily remove the Value Axis gridlines by selecting them and clearing them. But the Category and Series axis gridlines continue up onto the walls, and if I try to remove them then they are removed from the floor of the chart as well.

    What I basically want is to only have the floor with gridlines and the 3d columns with blank walls. Is this possible?

    Thanks

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Select the axis grid lines and format it to the same colour as the columns of your 3-D chart
    Last edited by oldchippy; 07-25-2007 at 09:06 AM.
    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

  3. #3
    Registered User
    Join Date
    07-24-2007
    Posts
    15
    Thanks for the reply oldchippy .. but that still doesn't help with my problem. The only way to get the gridlines to not show on the wall is to make them the same color as the wall. I would really like for the wall to be white or cleared and the gridlines to still be black.

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    I would really like for the wall to be white or cleared and the gridlines to still be black

    Click on the walls, Format set Border and Area to none - see example
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-24-2007
    Posts
    15
    Maybe I should have just attached my example from the get go. Now you should be able to see all of the manipulation I've done to the chart to get it how I want it, and how those gridlines sticking up are just annoying and I'm thinking it's either a VBA solution or just can't be done.

    Thanks again
    Attached Files Attached Files

  6. #6
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    It took me a while, but right click on the vertical lines and pick Clear

  7. #7
    Registered User
    Join Date
    07-24-2007
    Posts
    15
    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.

  8. #8
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    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?

  9. #9
    Registered User
    Join Date
    07-24-2007
    Posts
    15
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1