title: Create Excel Pivot Charts Or Graphs From Multiple Pivot Table Data Set
body: <p>I have a data set with multiple dimensions, time range and metrics but not in a standard format to create pivot charts. My objective is to create graphs which will show the time series data of the metrics by the offer types.</p>
  
  <p>I can edit and create appropriate columns and make the completely tabular but that will require some work. Is there any other way? I also have access to <a href="https://www.microstrategy.com" rel="nofollow noreferrer">microstrategy</a>.</p>
  
  <p><a href="https://i.stack.imgur.com/BnBLA.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BnBLA.jpg" alt="spreadsheet of pivot tables"></a></p>