2007-01-11, 00:52 #1
- Join Date
- Jan 2001
- Thanked 0 Times in 0 Posts
Data labels in scatter (Office 2003)
I need to create 3 buttons that the user can click to see Series 1, Series 2 or both. I need the data labels and symbols to appear or disappear. I used JWalk tools to get the data labels to appear as they come from a different sheet than the source numbers. I don't know how to code the macro for the 3 buttons. Can anyone help me? Thank you.
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2007-01-11, 08:19 #2
- Join Date
- Mar 2002
- Thanked 16 Times in 16 Posts
Re: Data labels in scatter (Office 2003)
Actually hiding/showing the series would be a hassle. I'd create three charts - one for series 1, one for series 2, and one for both. Give the three charts exactly the same size and position. The code behind the buttons would set the Visible property of one chart object to True and that of the other two chart objects to False, for example
.ChartObjects(1).Visible = True
.ChartObjects(2).Visible = False
.ChartObjects(3).Visible = False