Description
Found in Excel v15.0.4693.1000
I've noticed some odd behavior when creating a Scatter Plot with Straight lines via macro or while recording a macro. If I'm recording a macro while creating such a chart, when I select with or without markers, I get the opposite of what I selected. If I go through the same series of steps without recording a macro, it behaves as expected.
Steps to Reproduce
- Insert some data into a worksheet. Data should have at least two columns
- Begin recording a macro
- Insert a new straight line, no marker scatter plot without selecting any data
- Select the blank chart, type CTRL+X to cut
- Paste it into some location in the worksheet (I known step 4 and 5 seems trivial but it doesn't happen without them)
- Go to the Design tab, and click Select Data
- Add a series
- Select the data for the series
- Click OK
- ClickOK
Expected Result
Chart should get created without markers
Actual Result
Chart gets created with markers
Other Observations
I recorded a new macro while changing the chart type. When I changed to a no-marker plot, the ChartType constant in the VBE showed xlXYScatterLines. When I changed to a marker plot, the ChartType constant in the VBE showed xlXYScatterLinesNoMarkers.
Edit: In the other observation, it must be a new macro recording. I tried it again in the same recording as the steps to reproduce and it didn't happen.
- Edited by dfoakley 14 hours 16 minutes ago Added more info