Solved

excel 2007 vba, axis, removing Subtle Line shape

Posted on 2013-10-25
3
413 Views
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.

Thanks.
0
Comment
Question by:gofasteddie
  • 2
3 Comments
 
LVL 48

Expert Comment

by:Rgonzo1971
ID: 39600574
Hi,

Could you send example?

Regards
0
 

Accepted Solution

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

.TickLabels.Format.Line.Visible = msoFalse
0
 

Author Closing Comment

by:gofasteddie
ID: 39618536
Resolved in the meantime.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

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,…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

759 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

21 Experts available now in Live!

Get 1:1 Help Now