adding new series in this manner works but the lines are drawing in a vertical format and not horizontal across the chart at the specificied point, e.g. 1807 from the previous example. I have tried to manipulate the formatting of these statements but have been unsuccessful.
Any additional thoughts?
Ok I got this to work but I actually don't want to change the major and minor scale. In addition to the grid/scale, I am trying to draw addtional lines across the chart at specific levels within the x axis. Example: vb builds the chart, the x-axis scale is from 1780 to 1820 increments of 5. I...
I am trying to draw lines on a chart generate by a vb program in Excel. Attempting to use the .shapes.addline but I am having problems with formating the code correctly. In the end I am not sure this is the result I am after because I am really trying to draw lines based on a specific value...
