- Joined
- Mar 3, 2012
- Messages
- 1
- Reaction score
- 0
Hi guys,
Was hoping you can help me out, I have created codes to draw a series of scatter plot graphs. However, in addition to these, I would like to add in a number of straight lines, both vertical and horizontal, onto the graph. These lines are going to be based on existing data.
The way I got my spreadsheet set up, at the moment I have for the horizontal lines 3 different columns, with each row representing a different line. Column 1 is the line's starting X value, column 2 the line's ending X value, and column 3 is the Y value of the line.
I guess what my question boils down to is instead of writing something like
.XValues = Range ("B2:B10") or whatever,
Can I do something more like:
.XValues = Range("B2", "B2")?
Was hoping you can help me out, I have created codes to draw a series of scatter plot graphs. However, in addition to these, I would like to add in a number of straight lines, both vertical and horizontal, onto the graph. These lines are going to be based on existing data.
The way I got my spreadsheet set up, at the moment I have for the horizontal lines 3 different columns, with each row representing a different line. Column 1 is the line's starting X value, column 2 the line's ending X value, and column 3 is the Y value of the line.
I guess what my question boils down to is instead of writing something like
.XValues = Range ("B2:B10") or whatever,
Can I do something more like:
.XValues = Range("B2", "B2")?