title: Excel VBA code to change pivot chart type
body: <p>I'm looking for a code to create a button which upon clicking will change the pivot table chart from a bar chart to a line graph. I want the button to be at the bottom of the graph so the user can choose how they can see the data at the click of a button. </p>
  
  <p>Does anyone know the code for this? Ideally a plug and play solution as I'm a beginner to VBA</p>
  
  <p>Thanks </p>