border format

I'm trying to update graphs for scientific journals-style publications and can't seem to figure out how to move/shift the axis bar to the solid line border. Is this even possible with excel? Please see attached figures. The heat flow one is my graph and the other is how I would like it to look...

Hi, I am looking for VBA code that can select a range from the currently active cell down to the next border. There are random blank cells in the column, which prevents me from being able to 'select all' to the next blank cell. There are multiple tables, which vary in size and are arranged...

I have written some code to create and format pie charts, but I can't find how to add a border around each piece of pie. Excel generates the pie chart with only a default interior colour, and no border to each piece. As one piece needs to be white a border is critical to see it against the white...

Hi all! I am currently working on an Excel file that could be considered a work of art. I am sure we have all found ourselves in a position where you look at your work and say, "Hey!, who said these spreadsheets can't be fashionable!?" Having said that, I would like to create a visual effect...

Hi Excel 2007 For Application.ThisCell.Borders.LineStyle = What are my = options?

I'm sure there's a quicker way and also not sure what is wrong with my code but I need the code to loop through a workbook, making changes only to the worksheets listed in the array. The change needed is to clear all borders in cells F62:F165 with the exception of the right border. My code...