2014-06-15, 11:16 #1
- Join Date
- Apr 2003
- Vail, Colorado, USA
- Thanked 0 Times in 0 Posts
Add Vertical Line to an Excel chart with VBA
First I am using Excel 2011 for Mac and all I can find on the Web seems to refer to windows versions of Excel.
I have a cumulative frequency chart (line ) and I would like to add a vertical line/bar for the average in the data set.
So far I have managed to add a second series with 0 for all the data points but the average,and by changing the chart type for that series to bar it nearly gets there. This seems to be very clumsy and does not really show the proper position of the average as the only way I can create a new series is fit the average into the most appropriate bin. I think i need to pin the average to a X Range that starts at 1 and ends at the highest number in the cumulative frequency.
While I need to do this using VBA at present I am just trying to put a chart into place on a worksheet. I have the code to build the cumulative frequency chart but that's all.
Thanks you any suggestions appreciated.
Subscribe to our Windows Secrets Newsletter - It's Free!
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!