Excel create Scatter Plot by macro bug

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

  1. Insert some data into a worksheet.  Data should have at least two columns
  2. Begin recording a macro
  3. Insert a new straight line, no marker scatter plot without selecting any data
  4. Select the blank chart, type CTRL+X to cut 
  5. Paste it into some location in the worksheet (I known step 4 and 5 seems trivial but it doesn't happen without them)
  6. Go to the Design tab, and click Select Data
  7. Add a series
  8. Select the data for the series
  9. Click OK
  10. 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
June 11th, 2015 1:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics