excel 2007 vba, axis, removing Subtle Line shape

Posted on 2013-10-25
Last Modified: 2013-11-02
Excel 2007, so the macro recorder is )&((&$%*&.

Need to remove the "Subtle Line" shape that is created.

Can do it via Chart Tools, but emasculated recorder is little help.

Question by:gofasteddie
  • 2
LVL 49

Expert Comment

ID: 39600574

Could you send example?


Accepted Solution

gofasteddie earned 0 total points
ID: 39605696
Thanks for your response.  Resolved in the meantime.

.TickLabels.Format.Line.Visible = msoFalse

Author Closing Comment

ID: 39618536
Resolved in the meantime.

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ms office troubleshooting for users 8 36
Excel Copy Macro down foe each row 4 21
increment numbers by 10 11 31
Excel - Open, modify and save text file 4 13
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now