Thanks, Derick Assuming you are running the macro from the form the sheet on which you want to hide the gridlines( so that it is the active sheet), the following will hide them. Display Gridlines = False At the end of your macro turn them back on by setting the above to TRUE Hi Derick, A little tip - with things like this its always worth trying to use the Macro Recorder while you carry out the action and then examining the code.This would have given you the code that Tom has supplied Anyway, to cover the situation where the gridlines are already off you could try something along these lines: Thanks Tom and Richie. I am now wondering how to do it so if gridlines were off it leaves them off afterward, and if they were on, it puts them on again afterward (ie. I don't need a message box, just needs to run automatically.This technique plotted the XY chart data on the primary axes and the Area chart data on the secondary axes.It also took advantage of a trick using the category axis of an area (or line or column) chart: when used as a date axis, points that have the same date are plotted on the same vertical line, which allows adjacent colored areas to be separated by vertical as well as horizontal lines.Shading between plotted lines with a light color can enhance some charts.
Has VBProject Then File Ext Str = ".xlsm": File Format Num = 52 Else File Ext Str = ".xlsx": File Format Num = 51 End If Case 56: File Ext Str = ".xls": File Format Num = 56 Case Else: File Ext Str = ".xlsb": File Format Num = 50 End Select End If End With ' 'Change all cells in the worksheet to values if you want ' With Destwb. The tips and ideas you find here are designed specifically for users of Excel 2007, Excel 2010, and Excel 2013.You can sign up for the newsletter by using the simple sign-up form at the right side of this page or any page on the Excel Tips website. Simple data, simple chart of type Scatter With Straight Lines and Markers.We need to do some calculations to produce data for the area chart series (see below).