title: Openpyxl Hide Series Data Points from Legend
body: <p>I have a chart I've created using openpyxl. Everything turns out as expected, however I would like to hide the data points from the legend while keeping their formats in the chart. In short, I would like to hide/remove all of the data points from the right hand side of the chart while preserving the colors of the bars.<a href="https://i.stack.imgur.com/QZiyW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QZiyW.png" alt="enter image description here"></a> </p>
  
  <p>Here's a snippet of code used to build the chart: </p>
  
  <pre><code>chart1 = BarChart()
  series = chart1.series[0]
  
  ndcs = Set()
  scfs = Set()
  
  for i, row in enumerate(results):
      if 'DNDC' in row[0]: ndcs.add(i-1)
      if 'DSCF' in row[0]: scfs.add(i-1)
  
  
  for index in ndcs:
      fill =  PatternFillProperties(prst="pct5")
      fill.background = ColorChoice(prstClr="red")
  
      pt = DataPoint(idx=index)
      pt.graphicalProperties.pattFill = fill
      series.dPt.append(pt)
  
  for index in scfs:
      fill =  PatternFillProperties(prst="pct5")
      fill.background = ColorChoice(prstClr="blue")
  
      pt = DataPoint(idx=index)
      pt.graphicalProperties.pattFill = fill
      series.dPt.append(pt)
  </code></pre>
  
  <p>FWIW, I tried to follow the example from the docs <a href="http://openpyxl.readthedocs.io/en/default/charts/pattern.html" rel="nofollow noreferrer">here</a>, however I couldn't find anything specific about hiding the information on the legend. </p>
  
  <p>My question is, what members/attributes will I need to toggle off to hide the data points from showing on my legend while preserving the colors of the bars?</p>