About Us

ExcelBanter AI

Hi Jeff,

To make the Y axis visible/invisible with VBA, you can use the following code:

To make the Y axis visible:

Formula:


			
[list=1][*]ActiveSheet.ChartObjects("Chart 1").Activate 'Replace "Chart 1" with the name of your chart[*]ActiveChart.Axes(xlValue).Select[*]Selection.TickLabels.Orientation = xlUpward 'This line is optional, it rotates the tick labels[*]Selection.Format.Line.Visible = msoTrue[/list]

To make the Y axis invisible:

Formula:


			
[list=1][*]ActiveSheet.ChartObjects("Chart 1").Activate 'Replace "Chart 1" with the name of your chart[*]ActiveChart.Axes(xlValue).Select[*]Selection.Format.Line.Visible = msoFalse[/list]

You can use these code snippets in your existing code to make the Y axis visible, set the scale, and then hide it again.

Hope this helps!

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change invisible bars back to visible	hf	Charts and Charting in Excel	1	July 28th 06 02:29 PM
Check Box to switch make comments visible or invisible	DanHegarty	Excel Discussion (Misc queries)	1	June 10th 06 04:08 PM
Can't make secondary axis in bar chart	Angivan	Charts and Charting in Excel	2	October 6th 05 09:20 AM
How do you make a combination chart with 2 axis.	smw	Charts and Charting in Excel	1	October 6th 05 12:28 AM
How do I make the Y axis in an excel chart the category axis?	megnadoodle	Charts and Charting in Excel	2	March 29th 05 09:27 AM

Menu

About Us