I have some code to create a chart in VBA from a range, but I have two main problems at the moment:
1. How do I change "Series1" and "Series2" to the labels I want to use?
2.a. The source data is 3 columns. It's making all three columns into series, but I want the first column to be the x-axis.
2.b. Alternately, I don't need the first column because the values in it are the row numbers. But when I make the chart and try to select a range that doesn't start on row 1, it makes the x-axis start counting at 1 anyway, so all the x-values are wrong.
Please see attached file. What I want is for the chart to display the B and C columns, but I want to omit all rows where both are equal to 0 (they're bell curves so these are the tops and bottoms of the columns). If you click the "Make Chart" button, the look of the bars is pretty much how I want but the numbering on the x-axis is all wrong. The high points in the middle of the bell curves are supposed to be around x=200ish.
Bookmarks